1) For each of the following relations, indicate the normal form for that relation. If the relation is not in...

tietqnywandnrluzter

Main

Home >Homework Answsers >Information Systems homework help

1) For each of the following relations, indicate the normal form for that relation. If the relation is not in third normal form, decompose it into 3NF relations. Functional dependencies (other than those implied by the primary key) are shown where appropriate.

a. CLASS(CourseNo, SectionNo)
b. CLASS(CourseNo, SectionNo, Room)
c. CLASS(CourseNo, SectionNo, Room, Capacity)

[FD:RoomCapacity]
d. CLASS(CourseNo, SectionNo, CourseName, Room, Capacity) [FD:FD:ourseNo->CourseRoom; CRoomCapacity]

2) The Relation below stores information about weather observations made in the Albany area. You can assume that there are many observations made each day, that observer names are all unique, and that each observer measures the weather at just one location per day. Convert the relation them into a 3NF model and show the referential relationships. Don't add any additional fields.

(Date, ObserverName, Location, ObserverPhone, ObserverAddress, Time, CloudCover, Temperature, Humidity)

3) The Grade Report Table below shows a relation called Grade Report for a university. For this relation:

Draw a relational model and diagram the functional dependencies in the relation.
In what normal form is this relation in?
Decompose Grade Report into a set of 3NF relations.
Draw a relational model for your 3NF relations and show the referential relationships.

StudentID	StudentName	CampusAddress	Major	CourseID	CourseTitle	Instructor Name	Instructor Location	Grade
168300458	Williams	208 Brooks	page2image20792 IS page2image22040	IS 350	Database Mgt	Codd	page2image26304 B104 page2image27336	A
168300458	Williams	208 Brooks	IS	IS 465	Systems Analysis	Parsons	B317	B
543291073	Baker	104 Phillips	page2image40304 Acctg	IS 350	Database Mgt	Codd	page2image44392 B104	C
543291073	Baker	104 Phillips	Acctg page2image53000	page2image53296 Acct 201	Fund Acctg	page2image55880 Miller	H310 page2image58296	B
543291073	Baker	104 Phillips	page2image64872 Acctg	Mkgt 300	Into Mktg	Bennett	page2image69152