Question: Problem 4 . ( 2 5 points ) Given the relation below and the associated functional dependencies: A = ( M , N , P

Problem4.(25points)
Given the relation below and the associated functional dependencies:
A=(M,N,P,Q,R,S,T,U,V,W,x)
xUVQ
RM
NU
WP
STV
xW
SNx
UR
(a) List the primary key for this relation. Explain your answer. Clearly state the PK (5 points)
(b) Assuming the table is in First Normal Form, put the table in Second Normal Form. Explain your answer and clearly designate your primary keys for each table. (5 points).
(c) Put the table in third normal form. Explain your answer and clearly designate your primary keys. You must show all the tables. (5 points)
 Problem4.(25points) Given the relation below and the associated functional dependencies: A=(M,N,P,Q,R,S,T,U,V,W,x)

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!