Consider the following relational schema: (Cal. Lect. 2016] Employee (cmpld, empName, empDept) Customer (custld. custName, salesRepld, rating) salesRepld is a foreign key referring to empld of the employee relation.

Assume that each employee makes a sale to atleast

one customer.

What does the following query return?

SELECT empName

FROM employee E

WHERE NOT EXISTS (SELECT custld

FROM customer C

WHERE C sales Repld = E.empld

AND Crating <> 'GOOD')

Given relations R(w.x) and S(y,z), the result of SELECT DISTINCT w, x FROM R, S Is guaranteed to be same as R, if

A multidimensional database schema with one central fact table and one table for each dimension is called:-

Consider the following tables (relations):

Students:

Performance:

Primary keys in the tables are shown using Underline. Now, consider the following query:

SELECT S.Name, Sum (P.Marks)

FROM Students S, Performance P

WHERE S.Roll_No = P.Roll_No

GROUP BY S.Name

The number of rows returned by the above query is

The Indian parliament passed the Information Technology Bill, which is regarded as the mother legislation regulating the use of computers, computer system and computer networks as also data and information in the electronic format, in the year

In order to maintain the consistency during transactions database provides

Following Functional Dependencies hold on R(A, B, C) as A->BC, B->CA, C->AB which is a combination of candidate keys