### Exam Year

Tribhuvan University

Institute of Science and Technology

2078

Bachelor Level / fourth-semester / Science

Computer Science and Information Technology( CSC260 )

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.

Attempt any Two Questions (2 x 10 = 20)

1

What are different types of Database users and their roles? Explain the Data independence with example.

2

What are the components of ER diagram? Explain the function of various symbols use in ER diagram. Construct an ER diagram to store data in a library of your college.

3

Explain deadlock and starvation. Explain Time stamp based protocol for concurrency control?

Attempts any Eight Questios (8 x 5 = 40)

4

What is difference between logical data independence and physical data independence?

5

Explain Relationship and Relationship sets with example.

6

Retrive the TName, SName, SPhone for “ABC” school using SQL from given relation as below.

TEACHER (TID, TName, TAddress, TQualification)
SCHOOL_TEACHER (SID, TID, No_of Period)
7

What is integrity? Explain different types of database integrity.

8

Define Functonal dependencies. Explain trival and non trival dependencies?

9

Explain the difference between “Join” and “Natural Join” of algebriac operations with example.

10

What is Checkpoints in database recovery? How does it help in database recovery? Explain.

11

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

12

Define Boyce-Codd normal form with example. How it is different that 3rd Normal form.