Recent questions in Information and Communications Technology (ICT)

No documents found, press Enter to search

1.3 Multimedia Package: Types & Applications and use of Interactive White Board and Video Lessons

Multimedia Package: Types & Applications and use of Interactive White Board and Video Lessons
1

Answer Question given below

  1. Answer the following questions using SQL statements by referring the following relational schema. Note that the keys of the relations are underlined.
Employee (employee-name, city) Works (employee-name, Company-name, salary) Company (Company-name, city)i) Find the names, street address, and cities of residence who than $ 10,000. ii) Find the names of all employees in the database who live in the same cities as the companies for which they work. iii) Find the names of all employees in the database who do not work for ‘First Bank Corporation’. Assume that all people work for exactly one company. iv) Find the names of all employees in the database who earn more than every employee of ‘Small Bank Corporation’. Assume that all people work for at most one company. v) Find the names of all employees who earn more than the average salary of all employees of their company. Assume that all people work for at most one company.
1
1-6 of 8

Answer Question given below

  1. Answer the following questions using SQL statements by referring the following relational schema. Note that the keys of the relations are underlined.
Employee (employee-name, city) Works (employee-name, Company-name, salary) Company (Company-name, city)i) Find the names, street address, and cities of residence who than $ 10,000. ii) Find the names of all employees in the database who live in the same cities as the companies for which they work. iii) Find the names of all employees in the database who do not work for ‘First Bank Corporation’. Assume that all people work for exactly one company. iv) Find the names of all employees in the database who earn more than every employee of ‘Small Bank Corporation’. Assume that all people work for at most one company. v) Find the names of all employees who earn more than the average salary of all employees of their company. Assume that all people work for at most one company.
1

1.3 Multimedia Package: Types & Applications and use of Interactive White Board and Video Lessons

Multimedia Package: Types & Applications and use of Interactive White Board and Video Lessons
1
1-6 of 8
Information and Communications Technology (ICT)