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. 6:22 earn.senecacollege.ca + = X Introduction to Database S... > Project (25%) Marks You will be marked on your ability to: 477% 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. ||| 1 Include all of the necessary information from the case. O : 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. r 6:22 Scenario: nt.blackboardcdn.com + Activity: Analyze a 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. ||| Bb O Tasks: 4677% 2 Identify the Nouns Identify The Relationships Create a Conceptual Diagram r : + 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. 6:22 earn.senecacollege.ca + = X Introduction to Database S... > Project (25%) Marks You will be marked on your ability to: 477% 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. ||| 1 Include all of the necessary information from the case. O : 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. r 6:22 Scenario: nt.blackboardcdn.com + Activity: Analyze a 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. ||| Bb O Tasks: 4677% 2 Identify the Nouns Identify The Relationships Create a Conceptual Diagram r : +
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
-
Create physical data model for the attached case. 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...
-
An increase in the supply of U.S. dollars by the Federal Reserve will raise the value of the dollar because it will stimulate U.S. economic growth raise the value of the dollar because it will lead...
-
1. If I add sugar to a solution what will this do to the boiling temperature and freezing temperature? 2. Strand A of DNA GGCAGGCAT, Strand B of DNA AATAGCAA. Which strand would take the higher...
-
Find Vx in the circuit shown. + V, 2 V
-
Why are financial statements translated from one currency to another?
-
DeGraaf Office Supplies is a national retailer of office supplies, equipment, and furnishings. The company opened its first store in 1932, in Columbus, Ohio. Currently, DeGraaf has 300 stores...
-
Government spending as a fiscal policy tool is used to: A) ?Decrease the national debt B) ?Directly stimulate economic activity by increasing demand C) ?Reduce inflation D) ?Lower interest rates
-
Glenn Dental Clinic provides general dental care to residents of Philadelphia on walk-in basis. The clinic has started receiving complaints from patients that the waiting time is too long and has...
-
King Bathroom Fixtures (KBF) makes faucets, basins, and so on primarily for home use and sold through major retail chains. The design team at KBF has been working on a unique design to provide...
-
Common stock of company Zeta has a return of 4% with a probability of 0.2; return of 10% with a probability of 0.6; and a return of 20% with a probability of 0.2. Calculate the standard deviation of...
-
Calculate goodwill, if it is to be calucited at 3 years' purchase of the super profit: The firm started business with a cpaital of Rs. 4,00,000. The normal rate of earning in this class of business...
-
Nancy, is an African-American age 41-years-old, and her husband, David, age 47, arrive at a midwife clinic for an initial prenatal visit. They have been married for 10 years and trying to have a...
-
The insurance company offers full insurance against the potential loss of $(y z) from rain at a premium of $M, but the organizer may decide against full coverage by paying only a fraction f of the...
-
Amanda agrees to sell Louise her computer. Louise pays $1,300 for it today. She notices that, theoretically, she could have paid money continuously to Amanda over the next 8 years, with interest...
-
how to make a research proposal and the idea I thought in my mind is that i want to make a proposal on how I can emphasize the effect of plastic in my community, how can I measure the plastic waste...
-
5. How much would you need to deposit in an account now in order to have $5,000 in the account in 5 years? Assume the account earns 2% interest compounded monthly. 10. You deposit $300 each month...
-
John Williams (age 42) is a single taxpayer, and he lives at 1324 Forest Dr., Reno, NV 89501. His Social Security number is 555-94-9358. John's earnings and withholdings as the manager of a local...
-
For each of the following situations, indicate whether the taxpayer(s) is (are) required to file a tax return for 2012. Explain your answer. a. Helen is a single taxpayer with interest income in 2012...
-
During 2012, Tom sold Sears stock for $10,000. The stock was purchased 4 years ago for $13,000. Tom also sold Ford Motor Company bonds for $35,000. The bonds were purchased 2 months ago for $30,000....
-
Define marketing environment, and discuss the two parts that make up a companys marketing environment.
-
Technological advances are perhaps the most dramatic forces affecting todays marketing strategies. Imagine you are in the marketing department of a major brand familiar to you. How might new...
-
Consumers in the United Kingdom seem to be at the mercy of their own insurers. Hidden within the close print of the renewal notices is the true cost of renewing the insurance, often as much as a 100...
Study smarter with the SolutionInn App