problem 1) describe Natural Join in detail.
problem 2) What do you mean by ‘Domain’.
problem 3) describe ‘Cardinality’ of an Entity.
problem 4) Define ‘DCL’.
problem 5) What is Clustering Index ?
problem 6) describe Ordering Field or Key Field of an Ordered File.
problem 7) Describe use of Foreign Key Constraint.
problem 8) Name any 2 design goals of Relational Database.
problem 9) What are different types of the Database Users ?
problem 10) Consider the relation R = (A, B, C, D, G, H, I) and set of functional dependencies defined on R, F as
{A → B, A → C, CG → H, CG → I, B → H}
(i) Compute closure of F i.e. F+ and
(ii) Compute closure of Attribute Set (AG)+
problem 11) prepare a brief note on B+ Tree Index Files.
problem 12) What do you mean Aggregation ? describe with suitable ex.
problem 13) State rules to convert E-R diagram into tables.
problem 14) describe different File Organisations and describe Heap File Organisation in detail.