Questions
Syllabus
Qns. By Syllabus

Semester

Subject

Year

Tribhuwan University

Institute of Science and Technology

2079

Bachelor Level / Second Year / Fourth Semester / Science

B.Sc in Computer Science and Information Technology (CSC265)

(Database Management System)

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 Answers Questions

Attempt any TWO questions.
[2*10=20]
1.
What is Database Management System? Explain the DBMS architecture with a diagram. What is data independence?[10]
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.[10]
3.
What is normalization? Why normalization is required? Explain 1NF, 2NF, and 3NF with example.[10]
Section B

Short Answers Questions

Attempt any Eight questions.
[8*5=40]
4.
What do you mean by Schema and Instance in DBMS? Explain both with examples. [5]
5.
What is conflict schedule? Explain with example. [5]
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) [5]
7.
Explain aggregation with example. [5]
8.
Define functional dependencies. Explain 2nd normal form with example. [5]
9.
Explain Assertion and Triggers with example. [5]
10.
What is concurrency control? What are its advantages in DBMS? [5]
11.
What is Buffer Management in DBMS? Explain. [5]
12.
What is transaction? Draw states of transaction and explain. [5]