NAME 1) List the non-trivial functional dependencies for The Table. 2)Wich of th

Question

NAME

1) List the non-trivial functional dependencies for The Table.

2)Wich of the following normal forms is the table in? 1NF,2NF,3NF,BCNF (CHOOSE ALL THAT APPLY).

3)For each normal form wich it is not in,demonstrate why it is not in that normal form by describing the normal form violation for that normal form.

Please allow another Chegg Expert to answer this question if you can not answer it. The questions are very much clear.

NAME

DEPARTMENT ROOM BUILDING Smith Math 214 Wasdell David Math 212 Heinz Finch Math 214 Heinz ElGamal Math 236 Heinz Ramsey Math 212 Wasdell

Explanation / Answer

Ans 1) The non trivial functional dependency are:-

for given department maths there are many dependent values such as 214, 212,236. For given value of 214, there are two dependent values heinz and wasdell. For 212 ,there are two dependent values are heinz wasdell. The relationship can go vice versa.

Ans 2)The data is in 1st normal form.Since In first normal form, each row in table has unique values. However the data is still redundant.

Ans 3) The table is not in 2nd normal form. For that we need to split the main table up.

Name Room Smith 214 David 212 Finch 214 Elgamal 236 Ramsey 212

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.