Comic Book Collecting in UW Libraries’ Special Collection
59K - views

Comic Book Collecting in UW Libraries’ Special Collection

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 6,000) comic books. This is the first time that .

Download Presentation

Comic Book Collecting in UW Libraries’ Special Collection




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.



Presentation on theme: "Comic Book Collecting in UW Libraries’ Special Collection"— Presentation transcript:

Slide1

Comic Book Collecting in UW Libraries’ Special Collections

Final Project Part A

Prepared for INFX 543

by Chloe Horning

Slide2

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 Design

Slide5

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.

Slide7

Slide8