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?
In the history of database design, which of the following mo…
In the history of database design, which of the following models is not a type of database conceptual model?
The picture below shows a ticket for Super Bowl 57, which wa…
The picture below shows a ticket for Super Bowl 57, which was held in Glendale, Arizona, in February 2023. Identify six attributes from this ticket.
Given the following tables: Write SQL codes to add the foll…
Given the following tables: Write SQL codes to add the following data to the tables: 1) A new customer named Celine Jackson who lives in Tucson, Arizona 85641. Her customer ID is 78190. 2) A new product (Sun glasses) with 715 as product ID and $17.99 as unit price.
Given the following tables: Write a SQL code to list the cu…
Given the following tables: Write a SQL code to list the customers (customer ID, first name, last name, state, and zip code) who spent at least $500 in 2022.
Given the following ERD of a commercial bank: Provide the…
Given the following ERD of a commercial bank: Provide the list of customers (all columns in the Customer table) of the bank branches located in Arizona and who have an account balance of at least $10,000.
Examine the code below: SELECT Major, MAX(Gra…
Examine the code below: SELECT Major, MAX(Grade) AS FROM Student WHERE MAX(Grade) > 95GROUP BY MajorORDER BY Major; Select the right answer:
Given the following tables: Write a SQL code to provide the…
Given the following tables: Write a SQL code to provide the average length of time (in days) between sale date and shipping date by state. Your report should include the state and the average length of time. Order your list from the largest to the smallest time interval.
Using the database you have created for the health clinic, w…
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.
Again, using the database you have created for the health cl…
Again, using the database you have created for the health clinic, write a SQL code listing the patients (Patient ID, first name, last name, and age) of patients who were less than 15 years old on December 23, 2023.