Write down the database schema for these processes (these are the same processes as in Question 15). A rural hospital asks you to build a database to help them record the data of their care processes. Here are the processes. 1) Physicians consult many patients. 2) A patient can have more than one physician depending on their condition. 3) The management at the hospital wants to record for each physician, their name, specialization, year of graduation, office room number, and office phone number. 4) Patients are categorized based on whether they are inpatients (i.e., a patient who sleeps at the hospital for care) or outpatients (i.e., a patient who returns home after seeing their physician(s). A patient is either inpatient or outpatient. 5) For each patient, the hospital records their last name, first name, address, DOB, social security number, health insurance ID number, and medical diagnosis. 6) In addition, for outpatients, the hospital records the date of their next appointment and the name of the pharmacy where to send their drug prescription.7) For inpatients, the hospital records the date of their admission and the date of their discharge from the hospital. 8) The hospital also keeps data on the room where the inpatient stays. Inpatients stay in the same room throughout their stay at the hospital, and each room can accommodate a maximum of two inpatients. 9) For rooms, the hospital records the room number, the number of beds in the room (1 or 2 beds), and the phone number of the room.

What data type would you use for recording the following surname “Featherstonehaugh”:

You are creating a database to record data on cities across the United States. You want to know the average population per city. What data type would you select for the number of inhabitants in each city, knowing that this number ranges from one (1) inhabitant in Monowi, Nebraska to more than 8.8 million inhabitants in New York City? 

Given the following tables: Write a SQL code to list all the customers (first name, last name, and zip code) from the state of California.

Using the database you have created for the health clinic, write an SQL code to create a report that lists: the first name, last name, and insurance ID of patients who were seen today, as well as the first name, last name, and specialty of the physician who consulted these patients. Include an alias for every column in the table.      

Examine the SQL Code below: SELECT AccountantID,              LastName,              FirstName,             Gender,             SalaryWHERE Salary < 100000ORDER BY Salary; Select the right answer:

Given the following ERD of a commercial bank:   Write a SQL code that lists customers who opened an account before the year 2020. List all the columns in the customer table. The date an account was opened is recorded in the OpenDate column of the Account entity.

Given the following tables: The customer with the ID 16784 (Tiffany Clinton) now lives in Florida in the zip code 33411. Write a SQL code to make the appropriate change to the database.

Social class positions do not have major influence on mental or physical health of people

Instructions:Your final exam allows the following:Notes allowed – one self-prepared, double-sided reference sheet (US letter 8.5″ x 11″ or A4 size). This may be handwritten or typed and printed.Part 2 paper packet and pen/pencilHonorlock will record your webcam and screen throughout the exam.You will have access to the following:Microsoft ExcelIf you encounter Honorlock-related issues, raise your hand for in-person support. You may also contact Honorlock chat support for immediate help.