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](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f50ed5ab2a9_14966f50ed52e78f.jpg)
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
Get step-by-step solutions from verified subject matter experts
