Step 1. Draw an ER diagram for the story below. Use the ERD tool only. Draw Rela

Step 1.
Draw an ER diagram for the story below. Use the ERD tool only. Draw Relations in Oracle notation.
Use the mentioned Entities ONLY.
Various Products are sold to Customers. The Sales Agent creates an Order. A new order is created for each Product. Order includes Order Date, Product, Customer, Product Quantity, and Sales Agent.
Product has Description and UnitPrice.
Each Agent reports to a Manager. A Manger has a Name and Commission Percent.
NOTE: Total Amount is a calculation, doesn’t belong to Order
Step 2.
Add Attributes to Sales Order ERD based on Rules of Normalization.
Download in *.pdf, submit pdf file.

Leave a Reply

Your email address will not be published. Required fields are marked *