Total No. of Questions 18] [Total No. of Pages 02
M.Sc. DEGREE EXAMINATION, MAY 2018
First Year
COMPUTER SCIENCE
Database Management Systems
Time 3 Hours Maximum Marks :70
SECTION A
Answer any three questions. x 15 45)
Q1) Explain about various data models. And also give the applications of
DBMS.
Q2) Consider the following relations:
Suppliers sname, address)
Parts pname, color)
Catalog pid, cost)
Write the following queries in relational algebra, tuple relational calculus,
and domain relational calculus:
Find the names of suppliers who supply some red part.
Find the sids of suppliers who supply some red or green part.
Find the sids of suppliers who supply every part.
Q3) Explain the following in SQL with examples.
Nested Queries Correlated Queries Triggers
Q4) Discuss in detail about tree and hash based indexing techniques.
Q5) Explain in detail about Timestamp based and validation based protocols.
SECTION B
Answer any five questions. x 4 20)
Q6) What are the responsibilities of a DBA?
Q7) Write about generalization and specialization in E R diagram.
Q8) Explain commit and rollback command.
Q9) Describe various DDL and DML commands in SQL with syntax.
Q10) Write about first and second normal forms with example.
Q11) Briefly explain about data dictionary storage.
Q12) How are deadlocks handled in transaction processing?
Q13) What is concurrency? What are the three problems due to concurrency?
SECTION C
Answer all questions. x 1
Q14)Define weak entity.
Q15) Define primary key.
Q16) Define functional dependency.
Q17) Define serializability.
Q18) What is meant by database views?