Tribhuvan University

Institute of Science and Technology

2079

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.

Section A

Long Answer Questions.

1

What is Database Management System? Explain the DBMS architecture with a diagram. What is data independence?

2

What is entities and its types? How do we reduce different types of entities and relationships of ER diagram into Tables? Explain with assuming different types of entities and relations.

3

What is normalization? Why normalization is required? Explain 1NF, 2NF, and 3NF with example.

Section B

Short Answer Questions.

4

What do you mean by Schema and Instance in DBMS? Explain both with examples.

5

What is conflict schedule? Explain with example.

6

Retrieve the TName, and No_of_priod of teachers who teach in “ABC” school using Relational Algebra.

TEACHERĀ  (TID, TName, TAddress, TQualification)

SCHOOL (SID, SName, SAddress, SPhone)

SCHOOL_TEACHER (SID, TID, No_of Period).

7

Explain aggregation with example.

8

Define functional dependencies. Explain 2nd normal form with example.

9

Explain Assertion and Triggers with example.

10

What is concurrency control? What are its advantages in DBMS?

11

What is Buffer Management in DBMS? Expalain.

12

What is transaction? Draw states of transaction and explain.