Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I'm gonna be posting a series of questions so if anyone can help me with this it'll be great All answers must be explained. Problem
I'm gonna be posting a series of questions so if anyone can help me with this it'll be great
All answers must be explained. Problem 1 (30 points): Given Relation S2021 = ( A, B, C, D, E, F, G, H, I, J) and given these functional dependencies: {C} {H} {G} {A, B} {D} {F} {E, G} {J (E, 1} {A, C, D} a. Determine the Primary Key of S2021 (5points). b. Is {E, G, C, D } a key? Explain your answer (Spoints). c. Can you tell if this table is in first normal form(5points)? d. Is the table below in Second Normal Form? Explain. The primary key is underlined (7points). {E, G, J, A, B} e. Is the table below in Third Normal Form? Explain. The primary key is underlined (8points). {I, E, H, C, D, F}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