Customer_Order(OrderNo,CustomerNo,CustomerName(ItemCode,UnitPrice,QuantityOrdered,BranchNo,BranchLocation)*) where * denotes a repeating group. Each branch is capable of supplying all items and there can be more than 1 branch in the same location. Customer orders are processed centrally and branches are asked to supply items depending on their location and levels of stock of the item requested. derive a set of 3rd normal form(3NF) relations for this set of data. Underline all the keys clearly and state any assumptions that you make
So what I did first is
UNF to 1NF
1.Removed repeating group
2.found primary key
3.Added copy of previous primary key
Customer_order(OrderNo,CustomerNo,CustomerName)
Order1(Itemcode,CustomerNo,OrderNo,unitprice,quantityordered,branchno,branchlocation)
1NF to 2NF
1.list all functional dependencies
2.Identify partial dependencies
(orderNo,CustomerNo)->{CustomerName}
(CustomerNo->{CustomerName}
(Itemcode,CustomerNo,OrderNo)->{unitprice,quantityordered,branchno,branchlocation}
(itemcode)->{unitprice}
Customer_order(OrderNo,CustomerNo)
Customer2(CustomerNo,CustomerName)
Order1(Itemcode,CustomerNo,OrderNo,quantityordered,branchno,branchlocation)
Item2(Itemcode,unitprice)
2NF to 3NF
1.list functional dependencies
2.find transitive dependencies
(Itemcode,CustomerNo,OrderNo)->{quantityordered,branchNo,branchlocation}
(branchNo)->{branchlocation,quantityordered)
Customer_order(OrderNo,CustomerNo)
Customer2(CustomerNo,CustomerName)
Order1(Itemcode,CustomerNo,OrderNo,quantityordered,branchno,branchlocation)
Item2(Itemcode,unitprice)
Branch3(branchNo,branchlocation,quantityordered)
Now im confused where it says Customer orders are processed centrally and branches are asked to supply items depending on their location and levels of stock of the item requested thats why i put quantity ordered in Branch3 please let me know where im wrong pleaseee
halaandTheGod is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.