0 Replies - 280 Views - Last Post: 23 November 2013 - 09:32 AM Rate Topic: -----

#1 !java  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 24
  • Joined: 25-November 12

using fd's to get to BCNF

Posted 23 November 2013 - 09:32 AM

Hi guys I am the early stage of trying to grasp the concept of normalization. I have table that I am trying to create into BCNF any pointers will be appreciated. I will put the FD's in code and what I think is 1NF but be warned (I could be well off)
 FD'S
CustNo -> CustBal, CustDiscount
OrdNo ->CustNo, ShipAddr, OrderDate
ItemNo ->ItemDesc
ItemNo, PlantNo  ->  ReorderPoint, QtyOnHand
OrdNo, ItemNo ->  LineNo, QtyOrdered, QtyOutstanding
OrdNo, LineNo ->  ItemNo, QtyOrdered, QtyOutstanding

1NF Customer order(CustNo, CustBal, CustDiscount, OrdNo, ShipAddr, OrderDate, ItemNo, ItemDesc, PlantNo , ReorderPoint, QtyOnHand, LineNo, QtyOrdered , QtyOutstanding)




Is This A Good Question/Topic? 0
  • +

Page 1 of 1