4.6 Summary

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 in BCNF.

Index