4.1 Reduce to BCNF: Supplier Database

Reduce the following to BCNF, showing all the steps involved.
Supplier(sno,sname,saddress,(partno, partdesc,(custid,custname,custaddr,quantity)))
  sno -> sname,saddr
  partno -> partdesc
  sno,partno,custid -> quantity
  sname -> sno
  custid -> custname,custaddr
Suppliers supply many parts to many customers. Each customer deals with only one supplier. Supplier names are unique. Customer names are not unique.

Which of the following is a normalisation to 1NF?

  1. Supplier(sno,sname,saddress,(partno,partdesc))
    Cust-supp(partno,custid,sno,custname,custaddr,quantity)

     
  2. Supplier(sno,sname,saddress,(partno,partdesc))
    Cust-supp(partno,custid,sno,custname,custaddr,quantity)

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

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

     

Index