Create a physical data model for the attached case. Reference Please use the information located in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Create a physical data model for the attached case. Reference Please use the information located in the courseshell, as a guide when creating your models: Textbook Chapters 4, 5, 7, 8, 10, 13. What to submit: 1. SQL code of all database tables creation, PK, FK and constrains. 2. A schematic diagram of the database showing all types of relationships. 3. One page report of the challanges you face and your suggestions of how we can generalize the case. Marks You will be marked on your ability to: Include all of the necessary information from the case. Extrapolate what might be missing in the case and include components that are appropriate. Produce a professional, well written/organized, and or visually appealing response to each question. Activity: Analyze a Scenario Scenario: ABC Company uses a paper based, phone in ordering system. Currently, customers phone ABC with orders that are then written on forms for further processing. ABC Company would like to create an online ordering system to allow customers to place orders via the internet. The system will need to track customer information, including name, address, phone number The system should populate/collect order information, such as order date, required date, shipped date, status, comments. The system should also allow ordered products to be entered. For each product, the order also needs to include quantity ordered and unit price. Tasks: Identify the Nouns Identify The Relationships Create a Conceptual Diagram Create a physical data model for the attached case. Reference Please use the information located in the courseshell, as a guide when creating your models: Textbook Chapters 4, 5, 7, 8, 10, 13. What to submit: 1. SQL code of all database tables creation, PK, FK and constrains. 2. A schematic diagram of the database showing all types of relationships. 3. One page report of the challanges you face and your suggestions of how we can generalize the case. Marks You will be marked on your ability to: Include all of the necessary information from the case. Extrapolate what might be missing in the case and include components that are appropriate. Produce a professional, well written/organized, and or visually appealing response to each question. Activity: Analyze a Scenario Scenario: ABC Company uses a paper based, phone in ordering system. Currently, customers phone ABC with orders that are then written on forms for further processing. ABC Company would like to create an online ordering system to allow customers to place orders via the internet. The system will need to track customer information, including name, address, phone number The system should populate/collect order information, such as order date, required date, shipped date, status, comments. The system should also allow ordered products to be entered. For each product, the order also needs to include quantity ordered and unit price. Tasks: Identify the Nouns Identify The Relationships Create a Conceptual Diagram
Expert Answer:
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
The first quarter of 2008 had not yet ended and Steve Savage already knew the company would surpass the projected $22 million in revenues for the year. He and the management team had doubled sales...
-
You are a business continuity manager. Look ahead at potential changes in the coming 12 months and what these might mean for existing business continuity plans. Will the strategies in place in 2016...
-
Describe the makeup of the two simplest atoms, hydrogen (atomic number 1) and helium (atomic number 2).
-
Does a man standing in an elevator that is moving upward at a constant speed of \(10 \mathrm{~m} / \mathrm{s}\) feel heavier or lighter? What if the elevator is moving downward at the same speed? If...
-
1. Describe and evaluate the strategy directions pursued by CRH. 2. Describe and evaluate the corporate parenting roles employed by CRH. 3. Discuss CRHs acquisition strategy and its contribution. 4....
-
1. In the given reaction, XYZ3 2. 3. 4. 5. X+Y+3Z If one mole of each of X and Y with 0.05 mol of Z gives compound XYZ3. (Given: Atomic masses of X, Y and Z are 10, 20 and 30 amu, respectively.) The...
-
Mr. Geoffrey Guo had a variety of transactions during the 2019 year. Determine the total taxable capital gains included in Mr. Guo's division B income. The transactions included:? 1. On January 1,...
-
The most powerful 5G antennas work with a power of 120W. Assume that the human head is a sphere with a radius of 10 cm and that the human body is predominantly made of water. For simplicity, you can...
-
A company plans the construction of a winter-themed family amusement park in Alberta. The project details are as follows: . $1,000,000 in year 1 and $1,500,000 in year 2 for construction. $500,000 in...
-
You are requested to design a local road system in a residential area located in a mountainous terrain in New Nablus Suburban area. Area is restricted but need to have two traffic lanes and a parking...
-
Your company will purchase equipment worth $11,000,000. You consider financing the purchase through a loan with a 5 year term that requires end of month payments. The loan is fully amortized at the...
-
A client ask you to do a calculation to determine what the capital gains tax implication will be upon his death. The client has the following assets 1. Cash: R 1 000 000 2. Unit Trust Investment...
-
Conduct the force analysis of the structure for the given set of loads (shown in Figure 1), a provide the following: 1) Axial forces in all truss elements 2) Normal force, shear force, and moment...
-
1. Complete an individual in-depth competitive analysis of the video streaming industry in the US. For this analysis, compare four to five competitors and provide an in-depth strategic analysis of...
-
If 2 5 9 - k 5 8 = 2 5 8 , what is the value of k?
-
Mark owns his home and has a $250,000 mortgage related to his purchase of the residence. When his daughter went to college in the fall of 2012, he borrowed $20,000 through a home equity loan on his...
-
William sold Section 1245 property for $25,000 in 2012. The property cost $35,000 when it was purchased 5 years ago. The depreciation claimed on the property was $16,000. a. Calculate the adjusted...
-
Cypress Corporation has regular taxable income of $170,000 (assume annual gross receipts are greater than $5 million) and regular tax liability of $49,550 for 2012. The corporation also has tax...
-
Determine the work required to transport \(10 \mathrm{~kg}\) of material from Earth to the ISS, the International Space Station, in orbit \(420 \mathrm{~km}\) above the Earth's surface.
-
We normally think that dissipative forces tend to decrease the velocity of an object. This is correct for isolated systems. Consider the case of an artificial satellite of mass \(m\) in a circular...
-
An artificial satellite of mass \(m=2.5\) ton is in a circular orbit around the Earth at a distance of \(1600 \mathrm{~km}\) from the surface. Determine the magnitude of the satellite's angular...
Study smarter with the SolutionInn App