Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started