Rules to convert e-r diagram into tables

Question

Question 1) Explain Natural Join in detail.

Question 2) What do you mean by ‘Domain’.

Question 3) Explain ‘Cardinality’ of an Entity.

Question 4) Define ‘DCL’.

Question 5) What is Clustering Index ?

Question 6) Explain Ordering Field or Key Field of an Ordered File.

Question 7) Describe use of Foreign Key Constraint.

Question 8) Name any 2 design goals of Relational Database.

Question 9) What are different types of the Database Users ?

Question 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)⁺

Question 11) Write a brief note on B⁺  Tree Index Files.

Question 12) What do you mean Aggregation ? Explain with suitable example.

Question 13) State rules to convert E-R diagram into tables.

Question 14) Explain different File Organisations and describe Heap File Organisation in detail.