Design a database to keep track of information for restaurants. Assume that the following requirements were...

    

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.

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