Question: Hi! Could anyone help me out with this question? Problem 1 (30 points) Given Relation X = (A.B.C.D.E.F.G.H.I.J) and given these functional dependencies: {AB} >

 Hi! Could anyone help me out with this question? Problem 1

Hi! Could anyone help me out with this question?

(30 points) Given Relation X = (A.B.C.D.E.F.G.H.I.J) and given these functional dependencies:

Problem 1 (30 points) Given Relation X = (A.B.C.D.E.F.G.H.I.J) and given these functional dependencies: {AB} > {C} {B} -> {EF} {AD}-> {G.H} G} > {I} {H} > {J} a. Determine the Primary Key of X. b. Is {ADG} a key? Explain your answer. c. Is {ABDG} a key? Explain your answer. d. Can you tell if this table is in first normal form? e. When asked to put the table in 2NF. a student produce the following two tables. Explain why the student's answer is not in 2NF and then place the table in 2NF. The primary key is underlined. {A.B,C.E.F} {D.G.H.LI}

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 Economics Questions!