Questions
Syllabus
Qns. By Syllabus

Semester

Subject

Year

Tribhuwan University

Institute of Science and Technology

2078

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 are different types of Database users and their roles? Explain the Data independence with example.[10]
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.[10]
3.
Explain deadlock and starvation. Explain Time stamp based protocol for concurrency control?[10]
Section B

Short Answers Questions

Attempt any Eight questions.
[8*5=40]
4.
What is difference between logical data independence and physical data independence? [5]
5.
Explain Relationship and Relationship sets with example. [5]
6.
Retirve the TName, SName, SPhone for “ABC” school using SQL from given relation as below. [5]
7.
What is integrity? Explain different types of database integrity. [5]
8.
Define Functional dependencies. Explain trivial and non trivial dependencies? [5]
9.
Explain the difference between 'Join' and 'Natural Join' of algebraic operations with example. [5]
10.
What is Checkpoints in database recovery? How does it help in database recovery? Explain. [5]
11.
Define schedule and serializability. How can you test the serializability? [5]
12.
Define Boyce-Codd normal form with example. How it is different that 3rd Normal form. [5]