Build a 1-pg 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 make 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.

*Diamond Scale Reference*

• Clarity:IF- Internally Flawless
• VVS1 - Very, very slightly included (pavilion)
• VVS2 - Very, very slightly included (crown)
• VS1 - Very slightly included (under 10X magnification)
• VS2 - Very slightly included (to the naked eye)
• Color:D, E, F - Colorless - color between D, E, and F diamonds can be detected only by a gemologist in side by side comparisons, and rarely by the untrained eye
• G, H, I, J, K - Near Colorless - diamonds color rated by a gemologist

SophiaPretty

(5)

Status NEW Posted 09 Nov 2017 11:11 AM My Price 9.00

----------- He-----------llo----------- Si-----------r/M-----------ada-----------m -----------Tha-----------nk -----------you----------- fo-----------r y-----------our----------- in-----------ter-----------est----------- an-----------d b-----------uyi-----------ng -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------. P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll -----------be -----------qui-----------ckl-----------y

Not Rated(0)

• Buy Answer