Suppliers ( sid ; sname ; city ; street )
Assume the following relational schema :
Suppliers ( sid ; sname ; city ; street )
Parts ( pid ; pname ; pcolor )
Catalog ( sid ; pid ; cost).
Assume each supplier and each street within the city is unique and ( sname, city ) forms a candidate key. No other functional dependencies, except those implied in the schema exist. Which of the following statements is true ?
AThe schema is not in 2 NF
BThe schema is in 2 NF, but not in 3 NF
CThe schema is in 3 NF. but not in BCNF
DThe schema is in BCNF.
Post your answers here:
Post
