sno -> sname,saddr
partno -> partdesc
partno,custid -> quantity
sname -> sno
custid -> custname,custaddr
custid -> sno
The relations are now in 3NF.
Which of the following is true?
- The relations are not in BCNF.
- The relations are in BCNF. The dependency sname -> sno isn't a problem because sname is a candidate key (because it was stated that the supplier names are unique).
- The relations are in BCNF because there are no candidate keys other than the actual keys.
- The relations are not in BCNF because there are transitive dependencies.