Question: You are given a schema R = ( student _ id , student _ first, student _ last, course _ id ) that models students
You are given a schema R studentid studentfirst, studentlast, courseid that models students and the classes that they are taking. We want to know if R is in NF As a reminder, a relation is in NF if every nonkey attribute of R is determined by the key and nothing but the key.
Propose a potential key of R For this key, please answer the following questions:
Is every nonkey attribute determined by the key?
Is every nonkey attribute determined by the whole key?
Is every nonkey attribute determined by nothing but the key?
Are we in NF If not, how can we decompose our relation to be in NF
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
