Question: Consider a relation R with Seven attributes T , U , E , S , D , A , Y . You are given the

Consider a relation R with Seven attributes T,U,E,S,D,A,Y. You are given the following dependencies:
SEY
TA
TDU
ADE
YS
Its candidate keys are {(T,D,S),(T,D,Y)}.
Tasks:
Q1. List non-prime attributes of the relation R.
Q2. Which of the following is a Not So Bad functional dependence? (Enter A, B, C, or D)
A.YS
B.TA
C.ADE
D. TD U
Q3. The relation R is in (Enter 1NF,2NF,3NF, or BCNF)
Consider a relation R with Seven attributes T , U

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