CSIT 4th Semester
Database Management System Board Question Paper 2081 Old Course

CSC 265-2081 ✡
Tribhuvan University
Institute of Science and Technology
2081
✡
Bachelor Level/Second Year/Fourth Semester/Science
Computer Science Information Technology (CSC 265)
(Database Management System)
(Old 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.

How is enhanced ER model different from ER model? Construct an ER diagram to store data in the library where students borrow books from the library. Make necessary assumptions.

2.

How do you implement referential integrity in SQL? Explain different types of Joins with suitable example of each.

3.

Explain two phase locking technique in detail. What do you mean by lock conversion?

Section B

Attempt any Eight questions

[8x5=40]
4.

What are the responsibilities of the DBA and the database designers?

5.

Explain database schema with appropriate example.

6.

Define the terms DDL, DML, SDL, VDL, and host language.

7.

What do you mean by domain of an attribute? Explain recursive relationship with example.

8.

Explain key constraint and constraints on NULL values.

9.

What are different relational algebra operations from set theory?

10.

Explain 3NF with example. Compare 3NF with BCNF.

11.

What do you mean by serializable schedule? What are desirable properties of transactions?

12.

What is write-ahead logging? What are Possible ways for flushing database cache to database disk?