20 likes | 24 Views
DBM 380 Week 2 Individual Assignment Sparkle Diamonds Project//tutorfortune.com<br><br>Click on below link to buy<br>https://tutorfortune.com/products/dbm-380-week-2-individual-assignment-sparkle-diamonds-project<br><br>DBM 380 Week 2 Individual Assignment Sparkle Diamonds Project<br><br>Instructions: 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 required. Build a 1-page Entity Relationship Diagram that models the required tables and relationships using Microsoftu00ae Visiou00ae, Lucidchart, or another software tool of your choice. The table design and relationships must support the following functionality: <br>u2022tCustomers - 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. u2022 Inventory Table - The sales team will want to query the inventory to find diamonds that meet the following specifications of their customers: <br>u2022tCost - what SD has paid for the stone<br>u2022tPrice - what SD will sell the stone for<br>Carat - weight <br>u2022tClarity - clarity scale for diamonds offered are IF, VVS1, VVS2, VS1, VS2*<br>u2022tCut - cut scale for diamonds offered are Excellent, Very Good, Good<br>u2022tColor - color scale for diamond offered are D, E, F, G, H, I, J*<br>u2022tOrder 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. *Diamond Scale Reference*<br>u2022tClarity: <br>u2022tIF- Internally Flawless<br>u2022tVVS1 - Very, very slightly included (pavilion)<br>u2022tVVS2 - Very, very slightly included (crown)<br>u2022tVS1 - Very slightly included (under 10X magnification)<br>u2022tVS2 - Very slightly included (to the naked eye)<br>u2022tColor:<br>u2022tD, 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<br>u2022tG, H, I, J, K - Near Colorless - diamonds color rated by a gemologist Write a 175- to 350-word Status Update for your Learning Team using Microsoftu00ae Word describing the work you have completed this week. The Status Update is a simple Microsoftu00ae Word document that lets the instructor know what the team has accomplished during the week.<br>Click on below link to buy<br>https://tutorfortune.com/products/dbm-380-week-2-individual-assignment-sparkle-diamonds-project<br><br>
E N D
DBM 380 Week 2 Individual Assignment Sparkle Diamonds Project//tutorfortune.com Click on below link to buy https://tutorfortune.com/products/dbm-380-week-2-individual-assignment-sparkle- diamonds-project D B M 3 8 0 We e k 2 I n d i v i d u a l A s s i g n me n t S p a r k l e D i a mo n d s P r o j e c t I n s t r u c t i o n s : S t a r t w o r k i n g o n y o u r L e a r n i n g T e a m D a t a b a s e a n d P r e s e n t a t i o n o u t l i n e d a b o v e w i t h d e l i v e r y i n We e k F o u r . B e g i n b y a n a l y z i n g t h e r e q u i r e me n t s p r o v i d e d . I d e n t i f y t h e t a b l e s , fi e l d s , fi e l d a t t r i b u t e s , a n d t a b l e r e l a t i o n s h i p s r e q u i r e d . B u i l d a 1 - p a g e E n t i t y R e l a t i o n s h i p D i a g r a m t h a t mo d e l s t h e r e q u i r e d t a b l e s a n d r e l a t i o n s h i p s u s i n g Mi c r o s o f t ® V i s i o ® , L u c i d c h a r t , o r a n o t h e r s o f t w a r e t o o l o f y o u r c h o i c e . T h e t a b l e d e s i g n a n d r e l a t i o n s h i p s mu s t s u p p o r t t h e f o l l o w i n g f u n c t i o n a l i t y : C u s t o me r s - E a c h c u s t o me r i s a s s i g n e d a u n i q u e c u s t o me r n u mb e r b u t ma y h a v e mu l t i p l e l o c a t i o n s t o s h i p t o . T h e s a l e s t e a m n e e d s t o b e a b l e t o s e l e c t t h e c u s t o me r a n d t h e l o c a t i o n f o r p r e p a r i n g s a l e s o r d e r s . • I n v e n t o r y T a b l e - T h e s a l e s t e a m w i l l w a n t t o q u e r y t h e i n v e n t o r y t o fi n d d i a mo n d s t h a t me e t t h e f o l l o w i n g s p e c i fi c a t i o n s o f t h e i r c u s t o me r s : C o s t - w h a t S D h a s p a i d f o r t h e s t o n e P r i c e - w h a t S D w i l l s e l l t h e s t o n e f o r C a r a t - w e i g h t C l a r i t y - c l a r i t y s c a l e f o r d i a mo n d s o ff e r e d a r e I F , V V S 1 , V V S 2 , V S 1 , V S 2 * C u t - c u t s c a l e f o r d i a mo n d s o ff e r e d a r e E x c e l l e n t , V e r y G o o d , G o o d C o l o r - c o l o r s c a l e f o r d i a mo n d o ff e r e d a r e D , E , F , G , H , I , J *
O r d e r T a b l e - T h e s a l e s t e a m w i l l w a n t t o p r e p a r e a s a l e s o r d e r f o r e x i s t i n g c u s t o me r s a n d s e l l o n l y d i a mo n d s t h a t a r e i n i n v e n t o r y . T h e D B MS mu s t b e d e s i g n e d s u c h t h a t c u s t o me r s c a n p u r c h a s e mu l t i p l e s t o n e s o n o n e s a l e s o r d e r . * D i a mo n d S c a l e R e f e r e n c e * C l a r i t y : I F - I n t e r n a l l y F l a w l e s s V V S 1 - V e r y , v e r y s l i g h t l y i n c l u d e d ( p a v i l i o n ) V V S 2 - V e r y , v e r y s l i g h t l y i n c l u d e d ( c r o w n ) V S 1 - V e r y s l i g h t l y i n c l u d e d ( u n d e r 1 0 X ma g n i fi c a t i o n ) V S 2 - V e r y s l i g h t l y i n c l u d e d ( t o t h e n a k e d e y e ) C o l o r : D , E , F - C o l o r l e s s - c o l o r b e t w e e n D , E , a n d F d i a mo n d s c a n b e d e t e c t e d o n l y b y a g e mo l o g i s t i n s i d e b y s i d e c o mp a r i s o n s , a n d r a r e l y b y t h e u n t r a i n e d e y e G , H , I , J , K - N e a r C o l o r l e s s - d i a mo n d s c o l o r r a t e d b y a g e mo l o g i s t Wr i t e a 1 7 5 - t o 3 5 0 - w o r d S t a t u s U p d a t e f o r y o u r L e a r n i n g T e a m u s i n g Mi c r o s o f t ® Wo r d d e s c r i b i n g t h e w o r k y o u h a v e c o mp l e t e d t h i s w e e k . T h e S t a t u s U p d a t e i s a s i mp l e Mi c r o s o f t ® Wo r d d o c u me n t t h a t l e t s t h e i n s t r u c t o r k n o w w h a t t h e t e a m h a s a c c o mp l i s h e d d u r i n g t h e w e e k . Click on below link to buy https://tutorfortune.com/products/dbm-380-week-2-individual-assignment-sparkle- diamonds-project