Begin by analyzing the requirements provided. Identify the tables, fields, field attributes, and table relationships required.
Build a Entity Relationship Diagram that models the required tables and relationships using Microsoft® Visio®, Lucidchart, or another software tool of your choice. The table design and relationships must support the following functionality:
- Customers - Each customer is assigned a unique customer number but may have multiple locations to ship to. The sales team needs to be able to select the customer and the location for preparing sales orders.
- Inventory Table - The sales team will want to query the inventory to find diamonds that meet the following specifications of their customers:Cost - what SD has paid for the stone
- Price - what SD will sell the stone for
- Carat - weight
- Clarity - clarity scale for diamonds offered are IF, VVS1, VVS2, VS1, VS2*
- Cut - cut scale for diamonds offered are Excellent, Very Good, Good
- Color - color scale for diamond offered are D, E, F, G, H, I, J*
- Order Table - The sales team will want to a sales order for existing customers and sell only diamonds that are in inventory. The DBMS must be designed such that customers can purchase multiple stones on one sales order.
Team Project but I'd like help with it as well as a description of the process.