CSIT 4th Semester
Database Management System Board Question Paper 2079

CSC 265-2079 ✡
Tribhuvan University
Institute of Science and Technology
2079
✡
Bachelor Level/Second Year/Fourth Semester/Science
Computer Science Information Technology (CSC 265)
(Database Management System)
(New Course)
Full Marks:60 Pass Marks:24 Time:3 hours

Candidates are required to give their answers in their own words as for as practicable.
The figures in the margin indicate full marks

Section A
Long Answer Questions
Attempt any Two question.
[2x10=20]
1.

What is Database Management System? Explain the DBMS architecture with 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

Attempt any Eight questions

[8x5=40]
4.

What do you mean by Schema and instance in DBMS? Explain both with example.

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? Explain.

12.

What is transaction? Draw states of transaction and explain.