Question: database systems, normal forms Consider the relations R with the attributes A, B, C, D, E and the corresponding functional depen- dencies F. Find all

database systems, normal forms database systems, normal forms Consider the relations R with the attributes A,

Consider the relations R with the attributes A, B, C, D, E and the corresponding functional depen- dencies F. Find all possible candidate keys for each scenario and decide, if the corresponding rela- tion fulfills the 1NF, 2NF or 3NF. Hint: You can assume that all attribute values are atomic. a) (0.5 points) R(A, B, C, D, E) with F = {D + E, A + BC, BC + AD} b) (0.5 points) R(A,BC,D,E) with F = { DB.C + AD, BEC} c) (0.5 points) R(A,B,C,D,E) with F = { BACE, EDADB} d) (0.5 points) R(A,B,C,D,E) with F = {AE+D, BCE + A} e) (0.5 points) R(A, B, C, D, E) with F = {CDE BABE CD}

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!