Attempt all the problems.

Section-A

problem1) Describe the three problems of concurrent transaction in RDBMS with appropriate exs.

problem2) What are Object-Oriented Database Management Systems?  Why do we require them?

problem3) What is the difference between schema & views?  What is Transaction Log?  What is its meaning?  When does transaction log get exhausted?  How do we overcome this problem?

problem4)(i) What is primary key?  How could a primary key be the foreign key?  Can a secondary key be a foreign key?

(ii) What is 3rd Normal Form?  How could 5th Normal Form be achieved?

Section-B

Case Study

The advertisement is issued giving essential qualifications for computer science programmes, last date for receipt of application, and fee to be enclosed with the application. A clerk in the Registrar’s office checks the received applications to see if mark sheet and fee are enclosed and sends valid applications to the concerned academic department. The department checks application in detail and decides the applicants to be admitted, those to be put in the waiting list, and those to be rejected. Suitable letters are sent to Registrar’s office which intimates the applicant.

problem5) Case problems:

a) Design DFDs corresponding to the above problem.

b) Draw the Enhanced-ER diagram for admission procedure in university showing all entities,  relationship, aggregation, generalization, and specialization)

c) Create normalized tables till 3NF