Tribhuvan University

Institute of Science and Technology


Bachelor Level / fourth-semester / Science

Computer Science and Information Technology( CSC265 )

Database Management System

Full Marks: 60 + 20 + 20

Pass Marks: 24 + 8 + 8

Time: 3 Hours

Candidates are required to give their answers in their own words as far as practicable.

The figures in the margin indicate full marks.

Section A

Attempt any Two questions(2 x 10 = 20)


What are the advantages of using Database Management System over traditional filing system? Explain different data models with example.


What is concurrency control? Name various methods of controlling the concurrency control? Differentiate between Binary lock and shared/Exclusive lock.


What is normal form? Explain their types. Explain about loss-less join decomposition.

Section B

Short Answer Questions(8 x 5 = 40)


What is data abstraction? What are three levels of data abstraction? Explain.


What is difference between Entities and Entity sets? Explain with example.


Create two table Courses (CID, Course, Dept) and HoD (Dept, Head) using SQL language with all constraints [Primary key, Foreign key and Referential Integrity]. Assume the types of attributes by your own.


Differentiate between Integrity and Security with example.


Define schedule and serializability. How can you test the serializability?


What is Granularity of data items? How does it effect in concurrency control?


Explain 2 phase locking technique in brief.


What are the different approaches of Database recover? What should log file maintain in log-based recovery?


Explain the use of primary and foreign key in DBMS with example. What is the role of foreign key?