Question: You are given a schema R = ( student _ id , student _ first, student _ last, course _ id ) that models students

You are given a schema R =(student_id, student_first, student_last, course_id) that models students and the classes that they are taking. We want to know if R is in 3NF. As a reminder, a relation is in 3NF if every non-key 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 non-key attribute determined by the key?
Is every non-key attribute determined by the whole key?
Is every non-key attribute determined by nothing but the key?
Are we in 3NF? If not, how can we decompose our relation to be in 3NF?

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!