Discussion Post: Design the ER Diagram
You will need to create a design to support Products, Orders, Customers and Suppliers. In addition, the design needs to support multiple products per order. Support customer branching. Some customers are one company but have multiple locations. From a technical point of view, please incorporate a many to many relationship. Finally, the design needs to support discounts or promotions.
There are the additional requirements for the ER Diagram. You are supposed to build off the skeleton that was initially developed in class.(the Database ER Diagram work is for the Cheese company)
o Support multiple products per order
o Support promotions and discounts
o Support countries
o Support customer branches
o Remove any calculation fields
o Are there any many to many opportunities?
The response must include a reference list. One-inch margins, double-space, Using Times New Roman 12 pnt font and APA style of writing and citations.