Learn and practice Aptitude questions and answers with explanation for interview, competitive exam (Pariksha Corner )

Wednesday, January 22, 2020

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

Post your comments here:

Post

Categories