GATE 2009 CS – Question 56
Relations: Suppliers(sid:integer, sname:string, city:string, street:string), Parts(pid:integer, pname:string, color:string), Catalog(sid:integer, pid:integer, cost:real). Primary keys are sid for Suppliers, pid for Parts, and (sid, pid) for Catalog. Each supplier and each street within a city has a unique name, and (sname, city) is a candidate key. No FDs hold except those implied by primary and candidate keys. Which is TRUE?
Practise this question in The GATE Grind →
Show answer and explanation
Correct answer: (A) Schema is in BCNF.
Explanation
We are sorry we couldn't write detailed soluition for this, we are working on it!, please consider asking your own AI, its just 2-3 clicks with very minimum effort