Verify that a database model diagram is included in the document, and complete the following:…

1. Create a logical data model diagram for the following conceptual data models:
   1. Customers
   2. Orders
   3. Order details
   4. Products
   5. Inventory
   6. Vendors
   7. Purchases
   8. Purchase details
   9. Shipping
2. Verify that the logical data model supports the following:
   • A third normal form (3NF)
   • Customer may place many orders over time
   • Order may contain many products on it
   • Product may be supplied by several vendors
   • Product must be reordered if inventory levels reach
   • Purchases made when inventory levels reach
   • Order may be shipped in stages, depending on availability of product
   • Shipping and fulfillment for all items and entire orders need to be tracked
3. Verify that the model includes all entities, attributes, primary and foreign keys, and relationships.
4. Provide a rationale for your logical data model.
5. Identify the steps taken to achieve 3NF.