Jason C' H' Chen, Ph'D'

1
Chapter 5
Jason C. H. Chen, Ph.D. Professor of MIS School
of Business Administration Gonzaga
University Spokane, WA 99258 chen_at_gonzaga.edu
2
2-a (p.203)
3
2-d (p.203)
4
2-b (p.203)
5
2-c (p.203)
6
3. The normal form for the relations are a.   
3NF
b.    3NF
c.    2NF CLASS (Course_No, Section_No,
Room) ROOM (Room, Capacity)
d.   1NF COURSE (Course_No, Course_Name) CLASS
(Course_No, Section_No, Room) ROOM (Room,
Capacity)
7
6. Transforming Table 5-2 to relations (p.204)
a) PART SUPPLIER
b)
c)
Insert anomaly we cannot insert a new vendor
unless we also include a part number. Delete
anomaly if we delete part information, we also
lose information about a vendor who supplies that
part. Modification anomaly if a vendor address
changes, we have to modify all records (or rows)
for that vendor.
8
6. d)
e) 1NF
f)