Database system for a retailer

Question: You are hired to design a database system for a big retailer in Dubai. The retailer wants to store data about manufacturers, products and customers. Manufacturer has a name, which is
unique, an address, and a phone number. Products have a model number and a type. Each product is made by one manufacturer, and manufacturers have different products. Customers are identified by
their social security number. They have email addresses, and physical addresses. An order is placed by one customer. A customer can place many orders. An order has a unique order number, and a date. Information about customer should be recorded in the database even though they did not place any order. Each order contains one or more products. Some products may or may not appear in any
order. Draw an entity relationship diagram (ERD) to model the above requirements


Last Completed Projects

# topic title discipline academic level pages delivered
6
Writer's choice
Business
University
2
1 hour 32 min
7
Wise Approach to
Philosophy
College
2
2 hours 19 min
8
1980's and 1990
History
College
3
2 hours 20 min
9
pick the best topic
Finance
School
2
2 hours 27 min
10
finance for leisure
Finance
University
12
2 hours 36 min