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]
Continue reading »

What is the role of normalization in the database design process?

QUESTION: What is the role of normalization in the database design process?   [signinlocker] SOLUTION   The role of normalization in the database design process is to render undesirable functional dependencies desirable. [/signinlocker]
Continue reading »