DBM 380 Week 2 Learning Team Sparkle Diamonds Project\tStart working on your Learning Team Database and Presentation outlined above with delivery in Week Four. Begin by analyzing the requirements provided. Identify the tables, fields, field attributes, and table relationships required.\tBuild a 1-page Entity Relationship Diagram that models the required tables and relationships using Microsoft\u00ae Visio\u00ae, Lucidchart, or another software tool of your choice. The table design and relationships must support the following functionality:\t\uf0a7 Customers “\ufffd 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.\t\uf0a7 Inventory Table “\ufffd The sales team will want to query the inventory to find diamonds that meet the following specifications of their customers:\t\uf0a7 Cost “\ufffd what SD has paid for the stone\t\uf0a7 Price “\ufffd what SD will sell the stone for\t\uf0a7 Carat “\ufffd weight\t\uf0a7 Clarity “\ufffd clarity scale for diamonds offered are IF, VVS1, VVS2, VS1, VS2*\t\uf0a7 Cut “\ufffd cut scale for diamonds offered are Excellent, Very Good, Good\t\uf0a7 Color\u00a0 “\ufffd color scale for diamond offered are D, E, F, G, H, I, J*\t\uf0a7 Order Table “\ufffd 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.\t*Diamond Scale Reference*\t\uf0a7 Clarity:\t\uf0a7 IF- Internally Flawless\t\uf0a7 VVS1 “\ufffd Very, very slightly included (pavilion)\t\uf0a7 VVS2 “\ufffd Very, very slightly included (crown)\t\uf0a7 VS1 “\ufffd Very slightly included (under 10X magnification)\t\uf0a7 VS2 “\ufffd Very slightly included (to the naked eye)\t\uf0a7 Color:\t\uf0a7 D, E, F “\ufffd Colorless “\ufffd 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\t\uf0a7 G, H, I, J, K “\ufffd Near Colorless “\ufffd diamonds color rated by a gemologist\tWrite a 175- to 350-word Status Update for your Learning Team using Microsoft\u00ae Word describing the work you have completed this week. The Status Update is a simple Microsoft\u00ae Word document that lets the instructor know what the team has accomplished during the week.\tSubmit the ERD and Status Update to the Assignment Files tab.<\/p>\n","protected":false},"excerpt":{"rendered":"
DBM 380 Week 2 Learning Team Sparkle Diamonds Project Start working on your Learning Team Database and Presentation outlined above with delivery in Week Four. Begin by analyzing the requirements provided. Identify the tables, fields, field attributes, and table relationships Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-209739","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/209739","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=209739"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/209739\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=209739"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=209739"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=209739"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}