i) Relation state

ii) Relation schema

iii) Arity

iv) Domain

i) Drop command

ii) Delete command

iii) Update command.

works (Pname, Cname, Salary)

lives (Pname, Street, City)

located-In (Cname, City)

write the following queries in SQL:

i) List the names of the people who work for the company ‘Wipro’ along with the cities they live in

ii) Find the names of the persons who do not work for ‘Infosys’.

iii) Find the people whose salaries are more than that of all of the ‘oracle’ employees.

iv) Find the persons who works and lives in the same city

ii) A-> BC , D->AE

Assume a car can be sold by multiple salesman and hence primary key is{CAR_No, Salesman_No}.

Additional dependencies are

Date_Sold-> Discount

Salesman_No-> Commission

i) Is this relation in 1NF, 2NF or 3NF? Why or why not?

ii) How would you normalize this completely?

T1 : R1(x); R1(z); W1(x);

T2 : 2(x); R2(y); W2(z); W2(y);

T3 : R3(x); R3(y); W3(y);

S1 :R1(x); R2(z); R1(z); R3(x); R3(y); W1(x); W3(y); R2(y); W2(z); W2(y);

S2 :R1(x); R2(z); R3(x); R1(z); R2(y); R3(y); W1(x); W2(z); W3(y); W2(y);