BBM 6th Semester
Database Management Board Question Paper 2025

TRIBHUVAN UNIVERSITY
FACULTY OF MANAGEMENT
Office of the Dean
April 2025
Full Marks:60 Pass Marks:30 Time:3 Hrs.
BBM /
Sixth Semester /
IT 232:
Database Management

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

Long Answer Questions
Section "A"

Brief Answer Questions:

[10 × 1 = 10]
1.

Define database.

2.

What is a Queries?

3.

What is composite key?

4.

List any two advantages of using centralized database.

5.

Define data independence.

6.

Give an example of one to one relationship.

7.

Write a syntax of delete operation in SQL.

8.

Define anomalies.

9.

Define transaction.

10.

Define database recovery.

Section "B"

Short Answer Questions: (Attempt any FIVE Questions)

[5 × 3 = 15]
11.

List and explain different database users.

12.

Explain shadow paging.

13.

Define specialization with an example.

14.

Explain ACID property.

15.

What is a view in SQL? Write syntax to create a view.

16.

Define Instance and schema in dbms.

Section "C"

Long Answer Questions: (Attempt any THREE Questions)

[3 × 5 = 15]
17.

Define Join and explain its types.

18.

Explain Two-phase locking concurrency control technique.

19.

Explain Recovery Techniques based on immediate update.

20.

Design an ER diagram for a Hospital Management System to track patients, doctors, departments, and appointments. The system should store information about patients, doctors, the departments they work in, and the appointments patients have with doctors.

Section "D"

Comprehensive Answer / Case / Situation Analysis Questions:

[12 × 10 = 20]
21.

Consider a database with the following scheme and write SQL queries for following questions.

Customer (C_id, CName , address, age)

Buys item (Code, iname, price, C_id)
a. Write DDL statement to create above schema.
b. Add new customer.
c. List the Name of customer whole age is greater than 50.
d. Update the address of customer to Kathmandu whose C_id = 110.

22.

Define Normalization. Explain 1NF, 2NF, 3NF and BCNF with example.