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
1-I(a), p.227
1-I(c)
3
2-a (p.227)
4
2-d (p.227)
5
2-b (p.227)
6
2-c (p.227)
7
3. The normal form for the relations are (make
sure that you know why and how to transform it to
3NF)
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)
8
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.
9
6. d)
e) 1NF
f)