Which normal form is found adequate in most relational opera
Which normal form is found adequate in most relational operations ?
A3 NF
B4 NF
C5 NF
D2 NF
Thursday, January 23, 2020
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.
