The GATE Grind

GATE 2009 CS – Question 56

Databases · Integrity Constraints and Normal Forms · 2 marks · Multiple choice

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?

  1. Schema is in BCNF.
  2. Schema is in3NF but not BCNF.
  3. Schema is in2NF but not3NF.
  4. Schema is not in2NF.

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

More Integrity Constraints and Normal Forms questions

All Integrity Constraints and Normal Forms questions →