GATE Papers >> CSE >> 2009 >> Question No 56

Question No. 56 CSE | GATE 2009

Consider the following relational schema:

Suppliers(sid:integer, sname:string, city:string, street:string)
Parts(pid:integer, pname:string, color:string)
Catalog(sid:integer, pid:integer, cost:real)

Assume that, in the suppliers relation above, each supplier and each street within a city has a unique name, and (sname, city) forms a candidate key. No other functional dependencies are implied other than those implied by primary and candidate keys. Which one of the following is TRUE about the above schema?

Answer : (B) The schema is in 3NF but not in BCNF.

No Comments
Leave a comment