Answered step by step
Verified Expert Solution
Question
1 Approved Answer
This problem is based on Elmasri's company database. For each of the following, specify the query using SQL this is a paper and pencil problem,
This problem is based on Elmasri's company database. For each of the following, specify the query using SQL this is a paper and pencil problem, you do not need to implement these queries, but if you want to implement them, you are free to do so Feel free to create views or to save queries (to help answer a more complex query) or to create other tables (eg: using the INTO command SQL to create the views and subqueries. ) if that helps you. If you are using views or subqueries, show the (a) What are the names of the projects on which the combined hours (i.e. the total of all the hours of all the employees who work on that project) are more than 50. (b) Specify the following view in SQL: A view that has the department name and the number of locations for that department for each department. Please note that here you have to use the "CREATE VIEW" statement (c) List the names of the projects such that every employee works on that project. (d) How many employees from the Administration department have at least three dependents. (e) What is the name of the department whose employees have the lowest average salary
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started