Relative Content

Tag Archive for normalizationdatabase-normalization

Hi guys need help to decompose a relation to 3NF

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