in Databases
2,700 views
0 votes
0 votes

  Specify the following queries in SQL on the COMPANY relational  database schema shown in figure 3.5 .Show the result of each query if it is applied to the COMPANY database in Figure 3.6   

  1. Retrieve the names of all employees in department 5 who work more than 10 hours per week on the ProductX project. 
  2. List the names of all employees who have a dependent with the same first name as themselves 
  3. Find the names of all employees who are directly supervised by "Franklin Wong". 
FIGURE 3.5: Schema diagram for the COMPANY relational database schema.
FIGURE 3.6:One possible database state for the COMPANY relational database schema
in Databases
by
2.7k views

Please log in or register to answer this question.

Related questions