Which one of these attributes can be used as primary key for a table containing data about the customers of a car dealership.

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. In your conceptual model, you will have (check all that apply):

What is the best data type for recording the number of employees in each branch of a bank?

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.