What are the undesirable functional dependencies in the relation instance of the STUCLASS relation schema shown in Exercise 6?

QUESTION:

What are the undesirable functional dependencies in the relation instance of the STUCLASS relation schema shown in Exercise 6?

 

[signinlocker]

SOLUTION

 

Snum → Sname, Snum → Major, Cname → Time, Cname → Room, Time → Cname, Time → Room.

[/signinlocker]

Leave a Reply

Your email address will not be published. Required fields are marked *