Question: Question No. 1 [Marks 30] Consider the following table OID Date Status ProdIDProdName Quantit CategoryID CategoryName 01 02 01 Tablet Tablet Tablet 100 30 Processed

 Question No. 1 [Marks 30] Consider the following table OID Date

Question No. 1 [Marks 30] Consider the following table OID Date Status ProdIDProdName Quantit CategoryID CategoryName 01 02 01 Tablet Tablet Tablet 100 30 Processed P1 P2 P1 Disprin Benadry 50 Disprin100 un 02 30 In Jun cess 30 Processed P1 P2 01 02 Disprin 50 Jan Benadryl70 Description of Attributes: OID: ID of the order placed Date: Date of the order placed Status: Current status of the order ProdID: ID of the product in an order ProdName: Name of the product Quantity: Quantity of the product in an order CategoryID: ID of the category of the product CategoryName: Name of the category Convert the above table in first normal form, second normal form and third normal form. You need to show the complete table(s) in each normal form

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!