Homework # 1

Homework # 7

Normalization

Due: 3/20/2001 ?

70-455

Information Resources Management

3/13/2001

50 points

Following are two possible database schemas resulting from the E-R models completed for homework #3. For each, develop a schema that is in 4^th Normal Form. Document any additional functional dependency assumptions that you make and identify all primary and foreign keys. Create keys if necessary.

1. Publishing (40 points)

Publisher (PubName, PubAddress, {JourName}, {BookTitle})

Journal (JourName, {JourAbbr}, EditorName, {ArticleTitle})

Book (BookTitle, {AuthorName}, {ReviewerName})

Author (AuthorName, AuthorEmail, AuthorAddr, {BookTitle}, {ArticleTitle})

Article (ArticleTitle, JourName, {AuthorName}, {ReviewerName})

BookReviewer (ReviewerName, ReviewerEmail, ReviewerAddr, PubName, {BookTitle})

ArticleReviewer (ReviewerName, ReviewerEmail, ReviewerAddr, {JourName, ArticleTitle})

JournalEditor (EditorName, EditorEmail, EditorAddr, {JourName})

2. Chemists & Equipment (10 points)

Chemist (ChemistName, {ProjectID, {EquipmentID, CheckedOutDate}})

Equipment (EquipmentID, EquipmentName)

Project (ProjectID, ProjectName)