Questions from Database Management

Q: For each student group, list the number of tutors who have

For each student group, list the number of tutors who have been matched with that group.

Q: Match the following terms and definitions: - agile software development

Match the following terms and definitions: - agile software development - database application - constraint - repository - metadata - data warehouse - information - user view - database management sys...

Q: For simplicity, subtype discriminators were left off many figures in this

For simplicity, subtype discriminators were left off many figures in this chapter. Add subtype discriminator notation in each figure listed below. If necessary, create a new attribute for the discrimi...

Q: List the total number of lessons taught in 2018 by tutors in

List the total number of lessons taught in 2018 by tutors in each of the three Status categories (Active, Temp Stop, and Dropped).

Q: Which tutors, by name, are available to tutor? Write

Which tutors, by name, are available to tutor? Write the SQL query.

Q: Which tutor needs to be reminded to turn in reports? Write

Which tutor needs to be reminded to turn in reports? Write the SQL query. Show how you constructed this query using a Venn or other type of diagram.

Q: This problem is based on the entire (“big” version)

This problem is based on the entire (“big” version) Pine Valley Furniture Company database. Write an SQL query that will find any customers who have not placed orders.

Q: Write an SQL query to list all product line names and,

Write an SQL query to list all product line names and, for each product line, the number of products and the average product price. Make sure to include all product lines separately.

Q: Modify P&E 6-46 to include only those product

Modify P&E 6-46 to include only those product lines the average price of which is higher than $200. Data from P&E 6-46: Write an SQL query to list all product line names and, for each product line, t...

Q: List the names and number of employees supervised (label this value

List the names and number of employees supervised (label this value HeadCount) for each supervisor who supervises more than two employees.