Design a database to keep track of information for restaurants. Assume that the following requirements were...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Design a database to keep track of information for restaurants. Assume that the following requirements were collected: • Each restaurant has a name, city and phone number. . Each restaurant is owned by at least one owner. We need to keep track of an owner's SSN, name, city, address, and phone number. Each restaurant serves many different foods. Each food has a name, type of food, country of food, and spice level. Each customer may like many different foods. Each customer has his/her SSN, name, birth year, and gender. ER Diagram: Relational: O-SSN 3 Name Phone Spice-level Country Name Owner C-SSN m Relationship Restaurant Serves m Food m City Address Phone Restaurent-Name City Food-Name Likes m 848 Customer Type Gender Birth-Year Relational: Owner (O-SSN[PK], Name, City, Address, Phone) Restaurant (Restaurant-Name[PK], City, Phone) Relationship (O-SSN[FK], Restaurant-Name[FK]) Food (Food-Name, Type, Spice-level, Country) Serves (Restaurant-Name[FK], Food-Name[FK]) Customer (C-SSN[PK], Name, Gender, Birth-Year) Likes (C-SSN[FK], Food-Name[FK]) Scenario Design a database to keep track of information for a hospital. Assume that the following requirements were collected: • Many patients get admitted in a hospital. Each patient has a name, ss#, address, and name of insurance provider. We also need to keep track of the date each patient gets admitted and gets checked out. . Many doctors work in a hospital. Each doctor has a name, doctor's ss#, address, and specialization. Doctors see patients and recommend some test. Each test is performed by a doctor. Each test has a test identification number, name of the test, and the outcome of the result. We also need to keep track of the date and time each test is performed. Design a database to keep track of information for restaurants. Assume that the following requirements were collected: • Each restaurant has a name, city and phone number. . Each restaurant is owned by at least one owner. We need to keep track of an owner's SSN, name, city, address, and phone number. Each restaurant serves many different foods. Each food has a name, type of food, country of food, and spice level. Each customer may like many different foods. Each customer has his/her SSN, name, birth year, and gender. ER Diagram: Relational: O-SSN 3 Name Phone Spice-level Country Name Owner C-SSN m Relationship Restaurant Serves m Food m City Address Phone Restaurent-Name City Food-Name Likes m 848 Customer Type Gender Birth-Year Relational: Owner (O-SSN[PK], Name, City, Address, Phone) Restaurant (Restaurant-Name[PK], City, Phone) Relationship (O-SSN[FK], Restaurant-Name[FK]) Food (Food-Name, Type, Spice-level, Country) Serves (Restaurant-Name[FK], Food-Name[FK]) Customer (C-SSN[PK], Name, Gender, Birth-Year) Likes (C-SSN[FK], Food-Name[FK]) Scenario Design a database to keep track of information for a hospital. Assume that the following requirements were collected: • Many patients get admitted in a hospital. Each patient has a name, ss#, address, and name of insurance provider. We also need to keep track of the date each patient gets admitted and gets checked out. . Many doctors work in a hospital. Each doctor has a name, doctor's ss#, address, and specialization. Doctors see patients and recommend some test. Each test is performed by a doctor. Each test has a test identification number, name of the test, and the outcome of the result. We also need to keep track of the date and time each test is performed.
Expert Answer:
Answer rating: 100% (QA)
a In this scenario the condition f is continuous over a b is fulfilled because the velocity function vt and the position function st are both given as ... View the full answer
Related Book For
The Essentials of Statistics A Tool for Social Research
ISBN: 978-1111829568
3rd edition
Authors: Joseph F. Healey
Posted Date:
Students also viewed these computer engineering questions
-
The following balances as at the 1 January 2020, were extracted from the accounting records of De Ligt Wholesalers. Balances at 1 January 2020 Land and Buildings Motor Vehicles at cost Accumulated...
-
In problem 3.1 at the end of Chapter 3, you calculated measures of central tendency for six variables for freshman and seniors. Three of those variables are reproduced here. Calculate the mean (if...
-
In problem 3.5 at the end of Chapter 3, you calculated measures of central tendency for four variables for 15 respondents. Two of those variables are reproduced here. Calculate the mean (if...
-
The following are selected items from the accounting records of Georgia Peach for the year ended December 31, 2015: Note payable to SmithField Bank . . . . . . . . . . . . . . . . . . . . . . . . . ....
-
What does it mean to say that economists use the scientific method? How do economists distinguish between models that work and those that dont?
-
For each of the following joint pdfs, find fX (x) and fY (y). (a) f X,Y (x, y)= 1/2 , 0 x 2, 0 y 1 (b) f X,Y (x, y)= 3/2 y2, 0 x 2, 0 y 1 (c) f X,Y (x, y)= 2/3 (x +2y), 0 x 1, 0 y 1 (d) f X,Y (x,...
-
What is ultimate risk? Give and explain the formula for ultimate risk.
-
Analyzing the Effects of Errors on Financial Statement Items Cohen & Boyd, Inc., publishers of movie and song trivia books, made the following errors in adjusting the accounts at year-end (December...
-
Entertain your small group with a creative synopsis of the lives and works of Mozart and Beethoven! Imagine you are overhearing a conversation between Mozart and Beethoven. Do they have anything in...
-
You have been assigned the task of putting together a statement for the ACME Company that shows its expected inflows and outflows of cash over the months of July 2013 through December 2013. You have...
-
You discover a savings account belonging to your great-grandmother. It has been earning 1% annually for 50 years. The balance is $35,712. How much money did your great-grandmother originally put in...
-
All U.S. states require children to attend school. Mandatory school attendance ends at ages 1618, depending on the state. The adult literacy rate in North America was 100% in 2016. Discuss how...
-
Consider the owner of a local boutique. She is deciding if she should upgrade the storage and display containers. The total cost would be $2,000, and the depreciation rate is 8% per year. The...
-
Some people think boxing may be in the decline phase of the product life cycle. Develop a strategy to extend the product life cycle of boxing.
-
What data from internal business processes will serve as inputs into a cost accounting system for your university? From which specific enterprise systems will this data be recorded and managed?
-
Describe the three types of route structures. Define or illustrate each.
-
A foundry produces automobile brake pads. A specific lot of 70 of these pads includes 10 with burrs that were overlooked in the manufacturing process. If a part is randomly selected from the lot to...
-
What are the principal alloying elements in SAE 4340 steel?
-
At a large urban college, about half the students live off campus in various arrangements and the other half live in dormitories on campus. Is academic performance dependent on living arrangements?...
-
Statewide, the police clear by arrest 35% of the robberies and 42% of the aggravated assaults reported to them. A researcher takes a random sample of all the robberies (N = 207) and aggravated...
-
The following table presents the scores of 15 states on three variables. Compute r and r2 for each combination of variables. Write a paragraph interpreting the relationship among these three...
-
Following are the weights, in pounds, for offensive and defensive linemen on the New York Giants National Football League team at the beginning of a recent year. a. Find the mean and median weight...
-
Following are the closing prices of Google stock for each trading day in May and June of a recent year. a. Find the mean and median price in May. b. Find the mean and median price in June. c. Does...
-
The following tables present the number of specimens that tested positive for Type A and Type B influenza in the United States during the first 15 weeks of a recent flu season. a. Find the mean and...
Study smarter with the SolutionInn App