4.4 2NF

Supplier(sno,sname,saddress)
Supp-part(sno,partno)
Cust-supp(partno,custid,quantity)
Part(partno,partdesc)
Cust(custid,custname,custaddr,sno) 

  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?

  1. There are no transitive dependencies. Thus the relation is in 3NF.
     
  2. The relation is not in 3NF.
     
  3. The relation is not in 3NF because sname -> sno is a transitive dependency.
     
  4. There are several transitive dependencies.
     

Index