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 (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
Get step-by-step solutions from verified subject matter experts
