Problem:
Using the data which is provided below, normalize the table up to third Normal Form No need to show the data in your answer. You’re only required to give the normalized design of tables as follows:
Table name (attribute1, attribute2, attribute3…)
The following is a sample report from UTM Restaurant demonstrating normalised data. You’re required to show the First, Second and Third Normal Forms of following:
Oid is Order Id and Odate is Order date
Mid is Menu Id, MenuName is name of menu,Qty is menu quantity ordered and price is menu price.
IngId is ingredient Id, IngName is ingredient name, and Qty employed is quantity of ingredient employed in the menu.
Bid is Beverage Id, BName is Beverage Name, BPrice is Beverge Price and BQty is Beverage quantity.