Questions from Database Management


Q: List the name of each employee, his or her birth date

List the name of each employee, his or her birth date, the name of his or her manager, and the manager’s birth date for those employees who were born before their manager was born; label the manager’s...

See Answer

Q: Write an SQL query to display the order number, customer number

Write an SQL query to display the order number, customer number, order date, and items ordered for some particular customer.

See Answer

Q: Write an SQL query to display each item ordered for order number

Write an SQL query to display each item ordered for order number 1, its standard price, and the total price for each item ordered.

See Answer

Q: Refer to the employee EER diagram in Figure 3-2.

Refer to the employee EER diagram in Figure 3-2. Make any assumptions that you believe are necessary. Develop a sample definition for each entity type, attribute, and relationship in the diagram. Dat...

See Answer

Q: Write an SQL query to display the total number of employees working

Write an SQL query to display the total number of employees working at each work center (include ID and location for each work center).

See Answer

Q: Write an SQL query that lists those work centers that employ at

Write an SQL query that lists those work centers that employ at least one person who has the skill ‘QC1’.

See Answer

Q: Write an SQL query to total the cost of order number 1

Write an SQL query to total the cost of order number 1.

See Answer

Q: Write an SQL query that lists for each vendor (including vendor

Write an SQL query that lists for each vendor (including vendor ID and vendor name) those materials that the vendor supplies where the supply unit prices is at least four times the material standard p...

See Answer

Q: Calculate the total raw material cost (label TotCost) for each

Calculate the total raw material cost (label TotCost) for each product compared to its standard product price. Display product ID, product description, standard price, and the total cost in the result...

See Answer

Q: For every order that has been received, display the order ID

For every order that has been received, display the order ID, the total dollar amount owed on that order (you’ll have to calculate this total from attributes in one or more tables; label this result T...

See Answer