Waiting for answer This question has not been answered yet. You can hire a professional tutor to get the answer.

QUESTION

It has to be about DIAMONDS

Build a 1-page Normalized Entity Relationship Diagram (ERD) 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 prepare 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.

Write a 175- to 350-word Status Update for your Learning Team using Microsoft® Word describing the work you have completed this week. The Status Update is a simple Microsoft® Word document that lets the instructor know what the team has accomplished

Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question