The following data model is designed to hold information relating to Customers Ordering Products. For this scenario we need to define the following facts: These facts define the requirements which the Database must meet and should be agreed between the Database User and the Database Designer prior to physical creation. The draft facts have been defined as: The Entities required should include: Customers Orders OrderLines Products Suppliers The Entities are related as follows: A Customer can have one or Many Orders An Order can contain One or Many Products (OrderLines) A Product can be associated with One or Many Orders A Supplier can supply One or Many Products The design allows a Customer to place zero, one or many Orders. An Order can be for one or many Products, and this Product can be associated with zero, one or many Orders (the reason for the Link_Order Product table) Please enforce referential integrity. Once the mentioned tables are created add 5-10 records in each table. When asking questions of the database we may need to know: 1. Which Products have been ordered by a Customer 2. What date/time was a particular Order dispatched 3. How many open Orders do we have in the system 4. What is the Total Order Cost for a certain Order 5. Which Supplier supplies a particular Product 6. How many of a certain Product do we have in stock 7. What is the mark-up on a certain Product The following data model allows these questions to be answered and allows the information contained above to be stored logically and in a structured manner. See Street Addresty Sucher A country d owode t Productos ehnote EN Super yen nouston aced ngad Purchase honderd Ingold Addresade hone The following data model is designed to hold information relating to Customers Ordering Products. For this scenario we need to define the following facts: These facts define the requirements which the Database must meet and should be agreed between the Database User and the Database Designer prior to physical creation. The draft facts have been defined as: The Entities required should include: Customers Orders OrderLines Products Suppliers The Entities are related as follows: A Customer can have one or Many Orders An Order can contain One or Many Products (OrderLines) A Product can be associated with One or Many Orders A Supplier can supply One or Many Products The design allows a Customer to place zero, one or many Orders. An Order can be for one or many Products, and this Product can be associated with zero, one or many Orders (the reason for the Link_Order Product table) Please enforce referential integrity. Once the mentioned tables are created add 5-10 records in each table. When asking questions of the database we may need to know: 1. Which Products have been ordered by a Customer 2. What date/time was a particular Order dispatched 3. How many open Orders do we have in the system 4. What is the Total Order Cost for a certain Order 5. Which Supplier supplies a particular Product 6. How many of a certain Product do we have in stock 7. What is the mark-up on a certain Product The following data model allows these questions to be answered and allows the information contained above to be stored logically and in a structured manner. See Street Addresty Sucher A country d owode t Productos ehnote EN Super yen nouston aced ngad Purchase honderd Ingold Addresade hone
