normalisation
Date: Wed, 29 Oct 2003 10:58:12 -0500
Message-ID: <3536427.1067443092_at_dbforums.com>
hi, i was just wondering if anyone can help me with normalisation and especially boyce codd normal form. i have got 10 tables put together, in th ehope they are in third normal form, but im not sure, and i require them to be in boyce codd form also:
customer(customerid, cname, caddress,dadress,cpostcode,ctelno)
product(productid,stockid,producttypeid,pname,pprice,siteid)
producttype(producttypeid,preoducttype,descritpion)
site(siteid,sname,saddress,spostcode,stelno)
stock(stockid,predocutid,producttypeid,stocklevel,minlevel,reorderlevel- ,supplierno)
orders(orderno,customerid,productid,producttypeid,creditno,siteid,stockid, paymentid,supplierno)
payment(paymentid,customerid,feepaid,feedue,dateofpayment)
supplier(supplierno,suppliertypeno,siteno)
suppliertype(suppliertypeno,supplierdescription)
please if there is anyone out there could they help me thanks alot
-- Posted via http://dbforums.comReceived on Wed Oct 29 2003 - 16:58:12 CET