ITM202
Database Management
(For CNM Cases)
Assignment - II
Assignment Code:
2016ITM202A2 Last Date of Submission: 30th April 2016
Maximum Marks: 100
Attempt all the questions. All the
questions are compulsory and carry equal marks.
Section-A
1 Explain the
three problems of concurrent transaction in RDBMS with suitable examples.
2 What are
Object-Oriented Database Management Systems?
Why do we need them?
3 What is the
difference between schema & views?
What is Transaction Log? What is
its significance? When does transaction log get exhausted? How do we overcome this problem?
4 (i) What is primary key?
How can a primary key be a foreign key?
Can a secondary key
be
a foreign key?
(ii) What is 3rd Normal Form? How can 5th Normal Form be achieved?
Section-B
Case Study
An advertisement is issued giving
essential qualifications for computer science programmes, the 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 the application in detail and decides the
applicants to be admitted, those to be put in the waiting list, and those to be
rejected. Appropriate letters are sent to the Registrar’s office which
intimates the applicant.
5. Case
Questions:
a)
Design
DFDs corresponding to the above problem.
b)
Draw
the Enhanced-ER diagram for the admission procedure in university showing all
entities, relationship, aggregation,
generalization, and specialization)
c)
Create
normalized tables till 3NF.
No comments:
Post a Comment