Final Project Part A Prepared for INFX 543 by Chloe Horning The Problem UW Libraries Special Collections was recently given a large donation of about 6000 comic books This is the first time that ID: 484566
Download Presentation The PPT/PDF document "Comic Book Collecting in UW Libraries’..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
Slide1
Comic Book Collecting in UW Libraries’ Special Collections
Final Project Part A
Prepared for INFX 543
by Chloe HorningSlide2
The Problem
UW Libraries Special Collections was recently given a large donation of (about 6,000) comic books. This is the first time that
SpecColl
has collected comics and a new
o
rganization system is needed to manage them.
Current plans for organization involve the creation of a fully keyword searchable flat file. However, as the collection grows, a relational database will allow users to perform more sophisticated queries. Slide3
Logical Design
Table Name
Data
Data Types
Comic Books
Item_ID
Item _Title
Volume
Issue
Year
INT Primary Key
VARCHAR(15)
VARCHAR
(3)
SMALLINT
SMALLINT
Publisher Imprints
Publisher_Code
Publisher_Name
Imprint_Name
Imprint_ID
Item_ID
Item Title
CHAR(2)
VARCHAR(15)
VARCHAR(15)
CHAR(3) Primary
Key
INT
VARCHAR(15)
Series
Series
_ID
Series_Name
Item_ID
Item
_Title
CHAR(4) Primary Key
VARCHAR (15)
INT
VARCHAR(15)
Creators
Creator_ID
Creator_Name
Item_ID
Item _Title
INT Primary
Key
VARCHAR (15)
INT
VARCHAR (15)Slide4
Conceptual DesignSlide5
Notes
The “Series” field exists to help accommodate crossovers, title changes, etc.
I plan to use three “Publisher Codes”: DC (D.C. Comics) MV (Marvel Comics) and SI (small and independent publishers). Slide6
Revisions to Initial Design
I have radically altered the structure of my database since reading the initial comments that were posted on the class message boards. Since it is the nature of comic books to have multiple authors, illustrators, concept originators and colorists , I added a “Creators” table, which has a many to many relationship with the “Comic Books” table. In fact, the “Publisher Imprints” and “Series” tables now have this relationship with the “Comic Books” table as well, because I need to accommodate for the fact that comic books often contain “crossovers” between series, imprints, or even publishers.