Solution-Names of all the employees with all their customers

Names of all the employees with all their customers

Assignment Help Computer Engineering

Reference no: EM132218892

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: EM132218892

Questions Cloud

Instantiate the two vehicle objects and display the objects : Create a class named Vehicle that acts as a superclass for vehicle types.

Generate and returns a code table for a given symbol count : Write a function gen_code_table(symb_cnt_table, offset)that generates and returns a code table for a given symbol count table, with the specified offset.

Explain where you would get the information to address : The preparation of a formal SEMP is usually a required portion of a contractor's proposal for a competitive system development program.

How many computers will be attached to the network : What kind of networking device is easiest to reconfigure? What kind offers the best access to the network medium's bandwidth between pairs of devices?

Names of all the employees with all their customers : Consider the following relational schema: employee(empId, empName, empDept) customer(custId, custName, salesRepId, rating) salesRepId is a foreign key.

Design an adt for a one-person guessing game : Design an ADT for a one-person guessing game that chooses n random integers in the range from 1 to m and asks the user to guess them.

Evaluate the impact of e-business strategies : COIT20250: Formulate and critically evaluate the impact of e-business strategies on organisational processes and outcomes.

Calculate the total medicare tax : Paul Robinson's filing status is married filing jointly, and he has earned gross pay of $2,850. Each period he makes a 403(b) contribution of 6.5% of gross pay.

What basis will she take in the property received : Jonna is a one-fourth partner in Andersen Partners. At the end of the year, her tax basis in her tax basis in her partnership interest was $25,000.

User Account

All Pages

Names of all the employees with all their customers

Reference no: EM132218892

Reference no: EM132218892

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