Question: Consider the following relation ANY: ANY ( aid , bid, cid, aName, bName, cName, since, description, location ) and functional dependencies F that hold over

Consider the following relation ANY:
ANY (aid, bid, cid, aName, bName, cName, since, description, location)
and functional dependencies F that hold over the relation ANY:
See the picture
Determine all candidate keys (possible primary keys) of ANY.
2. In which normal form is the relation ANY and why?
3. If relation ANY is not in 1NF,2NF or 3NF then decompose it, accordingly, taking care to
denote possible keys (both PKs and FKs).
 Consider the following relation ANY: ANY (aid, bid, cid, aName, bName,

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!