Draw an entity relationship diagram ERD using unified modelling language UML nation according to the below business rules. your design should be logical level-including primary and foreign key fields and remember to remove any many-to-many relationships. 1. all entities should have surrogate primary keys. 2.A customer can place many orders over and over time and each order is placed by exactly one customer. 3.The name and surname of a customer must be stored in the database 4.The date and status of an order must be stored in the database 5.Each order cab obtain many items and each item can be part of many different orders 6.The name description and unit price of every item must be stored in the database 7.When an item is added to an order, the quality ordered and the unit price of thr item must be stored 8.Each item in the database belongs to a catagory and a catagory has many items that belong to it 9.The name of each of the categories must be stored in the database
Draw an entity relationship diagram ERD using unified modelling language UML nation according to the below business rules. your design should be logical level-including primary and foreign key fields and remember to remove any many-to-many relationships.
1. all entities should have surrogate primary keys.
2.A customer can place many orders over and over time and each order is placed by exactly one customer.
3.The name and surname of a customer must be stored in the
4.The date and status of an order must be stored in the database
5.Each order cab obtain many items and each item can be part of many different orders
6.The name description and unit price of every item must be stored in the database
7.When an item is added to an order, the quality ordered and the unit price of thr item must be stored
8.Each item in the database belongs to a catagory and a catagory has many items that belong to it
9.The name of each of the categories must be stored in the database
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
Identify two business rules from the below Entity Relationship Diagram (ERD
by Bartleby Expert
