Answered step by step
Verified Expert Solution
Link Copied!

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 =(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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Management Systems

Authors: Mark L. Gillenson

3rd Edition

978-1119907466

More Books

Students also viewed these Databases questions

Question

Under what circumstances are pay differentials justified?

Answered: 1 week ago