Total No. of Questions 18] [Total No. of Pages 02
M.Sc. DEGREE EXAMINATION, MAY 2017
First Year
INFORMATION TECHNOLOGY
Database Management Systems
Time 3 Hours Maximum Marks: 70
SECTION A
Answer Any Three Questions (3×15=45)
Q1) Discuss the components of information systems and database management
systems.
Q2) State and explain about classification of data models.
Q3) What is normalization? Explain normalization of invoice and reorder reports.
Q4) Explain about integrated database management system (IDMS) and its
commands.
Q5) What is meant by database recovery? Explain about forward and backward
recovery mechanisms.
SECTION B
Answer Any Five Questions
Q6) Write about one to one and one to many associations with example.
Q7) Briefly explain about the indexed sequential file organization.
Q8) What is meant by physical, relative and logical key pointers?
Q9) Write a procedure to mapping from conceptual data model to relational data
model.
Q10) Write short note on data volume and usage analysis.
Q11) Describe different interactive SQL DDL commands.
Q12) Explain about PC FOCUS database description.
Q13) Describe different security mechanisms in brief.
SECTION C
Answer All Questions
Q14) Define decision support system.
Q15) Define conceptual data model.
Q16) What is relational algebra?
Q17) Define deadlock.
Q18) Define concurrency.