Questions from Database Management

Q: List the average number of customers per state (including only the

List the average number of customers per state (including only the states that are included in the Customer_T table). Hint: A query can be used as a table specification in the FROM clause.

Q: Not all versions of this database include referential integrity constraints for all

Not all versions of this database include referential integrity constraints for all foreign keys. Use whatever commands are available for the RDBMS you are using, investigate if any referential integr...

Q: Tyler Richardson set up a house alarm system when he moved to

Tyler Richardson set up a house alarm system when he moved to his new home in Seattle. For security purposes, he has all of his mail, including his alarm system bill, mailed to his local UPS store. Al...

Q: Write an SQL query to answer the following question: Which instructors

Write an SQL query to answer the following question: Which instructors are qualified to teach ISM 3113?

Q: Write SQL retrieval commands for each of the following queries:

Write SQL retrieval commands for each of the following queries: a. Display the course ID and course name for all courses with an ISM prefix. b. Display the numbers and names of all courses for which P...

Q: Write an SQL query to answer the following question: Is any

Write an SQL query to answer the following question: Is any instructor qualified to teach ISM 3113 and not qualified to teach ISM 4930? If yes, list the faculty ID and name of the instructor.

Q: Write SQL queries to answer the following questions: a.

Write SQL queries to answer the following questions: a. How many students were enrolled in section 2714 during semester I-2018? b. How many students were enrolled in ISM 3113 during semester I-2018?...

Q: Write SQL queries to answer the following questions: a.

Write SQL queries to answer the following questions: a. What are the names of the course(s) that student Altvater took during the semester I-2018? b. List the names of the students who have taken at l...

Q: Write an SQL query to answer the following questions: a

Write an SQL query to answer the following questions: a. Which students were not enrolled in any courses during semester I-2018? b. Which faculty members are not qualified to teach any courses?

Q: Determine the relationships among the four relations in Figure. List primary

Determine the relationships among the four relations in Figure. List primary keys for each relation and any foreign keys necessary to establish the relationships and maintain referential integrity. Pa...