Question 1)a) Define clustering.
b) Explain the functions of File manager?
c) What do you mean by the 2NF rule.
d) What are the integrity rules?
e) Write down the advantages of E/R model?
f) Explain the differences between trivial and nontrivial dependencies.
g) Define parameterized cursors.
h) Describe the various types of triggers.
i) Write down the difference between function and procedure?
j) Explain the advantages of relational algebra.
Question 2) The following relations structures are given:-
S(S#, SNAME, STATUS, CITY) PRIMARY KEY(S#)
P(P#, PNAME, COLOR, WEIGHT, CITY) PRIMARY KEY(P#)
SPJ (S#, P#, J#, QTY) PRIMARY KEY (S#, P#, J#)
FOREIGN KEY (S#) REFERENCES S
FOREIGN KEY (S#) REFERENCES P
FOREIGN KEY (J#) REFERENCES J
a) Write a command to get project numbers for projects supplied with at least all parts available from supplier S1.
b) Write a command to get supplier numbers for suppliers who supply the same part to all projects.
c) Write a PL-SQL to get part numbers of parts supplied to some project in an average quantity of more than 320.
d) Create the view consisting of supplier tuples for suppliers that are located in London.
e) What are 1NF, 2NF and 3NF rules?