Convert the following diagram into 2, and 3 NF. Mention at each step the dependencies. Consider TransactionID and ProductID as PK of the table.

 

2. Once the tables are in 3 NF, Write SQL queries to create tables including all the constraints.   After creating the tables, insert 5 rows in each table. You can assume the values and appropriate datatypes for each column.

 

3. Later, generate a report using report builder. The report must show the number of products manufactured by each  manufacturer (name). You can use any 3D chart/graph with data labels. There should be a title added for the report.

 

 

Transcribed Image Text:

TransactionID CustomerID CustomerName CustomerEmail TransactionDate TransactionTime TransactionTotalAmount Transaction Tax ProductID Product Description Product Category Product ManufacturerID ManufacturerName ProductListPrice Product PurchasePrice ProductQuantity Transaction Product Total TransactionID CustomerID CustomerName CustomerEmail TransactionDate TransactionTime TransactionTotalAmount Transaction Tax ProductID Product Description Product Category Product ManufacturerID ManufacturerName ProductListPrice Product PurchasePrice ProductQuantity Transaction Product Total