sno -> sname,saddr
partno -> partdesc
partno,custid -> quantity
sname -> sno
custid -> custname,custaddr
custid -> sno
The relations are now in 2NF.
Which of the following is true?
- There are no transitive dependencies. Thus the relation is in 3NF.
- The relation is not in 3NF.
- The relation is not in 3NF because sname -> sno is a transitive dependency.
- There are several transitive dependencies.