Reference no: EM131418581
Assignment: Tables and Status Update
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:
o Cost - what SD has paid for the stone
o Price - what SD will sell the stone for
o Carat - weight
o Clarity - clarity scale for diamonds offered are IF, VVS1, VVS2, VS1, VS2*
o Cut - cut scale for diamonds offered are Excellent, Very Good, Good
o Color - color scale for diamond offered are D, E, F, G, H, I, J*
o 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 during the week.
|
Probability of woman pregnancy test
: Further suppose that the test is 98% accurate. What s the probability that a woman whose test indicates that she is pregnant actually is?
|
|
Colloquial language in writing
: You are to define the phrases: Colloquial language in writing, Declarative statements in writing, paraphrasing, and Formal language in writing. Provide a short summary discussing each phrase or term (two to three paragraphs for each) and provide an e..
|
|
What did george do that may have concerned the bank
: Prepare an income statement, a statement of shareholders' equity, a balance sheet, and statement of cash flows for the period. What did George do that may have concerned the bank? Explain.
|
|
What is the probability that you win the tv
: What's the probability that the first person in line wins the TV?- You are the third person in line. What's the probability that you win the TV?
|
|
What sd has paid for the stone
: What SD has paid for the stone? The sales team will want to prepare a sales order for existing customers and sell only diamonds that are in inventory.
|
|
Evaluate company''s cash management activities during year
: From the following transactions, prepare a statement of cash flows for Emory Inc. in the proper form. The company began the year with a cash balance of $25,000. Describe and evaluate the company's cash management activities during the year.
|
|
Explain do you agree in given condition
: The candidate then attacks the incumbent mayor, saying that there is an unusually low level of homeownership in the city. Do you agree? Explain.
|
|
Estimate the companys expected profit
: The company charges an annual premium of $520. Estimate the companys expected profit on such policies if mortality tables indicate that only 2.6% of women age 65 die within a year.
|
|
Responsibilities of the human resources manager
: Interview the Human Resources Manager for your department or for a department which you are interested. Find out about their job, what education prepared them for the position, and the key elements of their position.
|