Question 1)a) What are integrity constraints? Briefly describe the different integrity constraints.
(b) What are exceptions? Describe the various exceptions in Oracle.
(c) Create a transparent Audit system for Cust_Mstr. The system should keep track of the records that are being deleted or updated. The functionality being when a record is being deleted or modified the original record details and the date of operation, operation, user who performed the operation are stored in the audit table, then the delete or update operation is to go through.
Cust_Mast(Cust_No, FName, MName, LName, DOB, Occup, Addr)
Question 2)(a) Describe what is canonical cover. Give the algorithm to compute canonical cover.
Given schema (A, B, C ) and F= { A BC, B C, A B, AB C } calculate the canonical cover for F.
(b) Describe multi valued dependency and Fourth normal form.
(c) Describe the different Armstrong’s axioms and why they are used.
(d) Describe the multi table clustering file organization.
Question 3)(a) Describe bitmap indices with example.
(b) What are the causes of bucket overflow in a hash file organization? What can be done to reduce the occurrence of bucket overflows.
(c) Describe the Updates on B+ trees with example.
(d) Describe the optimization of disk block access techniques
(i) scheduling
(ii) file organization
(iii) non volatile write buffers.