Solution-What does the following query return

What does the following query return

Assignment Help Computer Engineering

Reference no: EM132221718

Assignment

Consider the following relational schema: employee(empId, empName, empDept) customer(custId, custName, salesRepId, rating) salesRepId is a foreign key referring to empId of the employee relation.

Assume that each employee makes a sale to at least one customer. What does the following query return?

SELECT empName FROM employee E WHERE NOT EXISTS (SELECT custId FROM customer C WHERE C.salesRepId = E.empId AND C.rating <> `GOOD`);

(A) Names of all the employees with at least one of their customers having a ‘GOOD' rating.

(B) Names of all the employees with at most one of their customers having a ‘GOOD' rating.

(D) Names of all the employees with all their customers having a ‘GOOD' rating.

Reference no: EM132221718

Questions Cloud

Describe how digital signatures work : BN305 : Analyse and write a report on how the confidentiality and integrity is achieved in SSL communication, and how server & client agree on one cipher suit?

Write an executive summary of your study : Write an executive summary of your study. In the summary, include the ANOVA test results, your hypothesis and its resolution, and the implications.

How do the basic chemicals cycle through your ecosystem : Consider the meaning of the term "ecology." Select an area you would like to focus on (your favorite place or where you live). How do the basic chemicals.

How is population growth related to the problem : Use the Internet to find an environmentally related problem that is happening in your area. Present information about the history behind this problem including.

What does the following query return : Assume that each employee makes a sale to at least one customer. What does the following query return?

Discuss given problem related to environment and population : In order to understand environment and population the understanding of organizing and categorizing biodiversity, biomes, and ecosystems will contribute to the m

Create an application method holds two double variables : Create an application named Percentages whose main() method holds two double variables.

Explain the idea of limits to population growth : Describe the historical pattern of growth of the worldwide human population since our origin. Include in this historic overview the changes that have happened.

Designing an efficient regex in order to extract the data : FIT5196: Designing an efficient regex in order to extract the data from the file

User Account

All Pages

What does the following query return

Reference no: EM132221718

Reference no: EM132221718

Questions Cloud

Reviews

Write a Review

Computer Engineering Questions & Answers

Mathematics in computing

Ict governance

Implementation of memory management

Realize business and organizational data storage

What is the protocol overhead

Implementation of memory management

Define open and closed loop control systems

Prepare a proposal to deploy windows server

Security policy document project

Write a procedure that produces independent stack objects

Define a suitable functional unit

Calculate yield to maturity and bond prices

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT