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

What makes it interesting from an operations management

How to adapt for large-scale transnational it projects

Determine the potential impact of each hazard or threat

What is the memory operations dominate execution time

Evaluate how ericsson benefitted from amazon web services

Will you want an int or float or double

Write your own algorithm for computing square roots

Explain the concepts of object orientation methodology

Write the following r functions using nested loops

Determine what is a credible web site

Write a program that accepts any number of monthly sales

Discuss why clock skew might introduce differences

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT