Database Management System (CSC265) TU Board 2080 (new course) Question Paper – BSc CSIT Semester 4

Tribhuvan University

Bachelor of Science in Computer Science and Information Technology

Semester 4 · TU Board 2080 (new course)

Course Title: Database Management System (CSC265)

Full Marks: 60Pass Marks: 24Time: 3 hours

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

Group A

Attempt any TWO question.(2 × 10 = 20)

1.
Consider a banking database with three labels and primary key underlined as given below:

Customer (CustomerID , CustomerName, Address, Phone, Email)

Borrows (CustomerID, LoanNumber )

Loan ( LoanNumber , LoanType, Amount )

Write both relational algebra and SQL queries:
1. To display name of all customers who live in "Lalitpur" in ascending order of name.
2. To count total number of customers having loan at the bank.
3. To find name of those customers who have loan amount greater than or equal to 500000.
4. To find average loan amount of each accoun't type.
Answer comingAlso asked in 2080
10
2.
What are informal design guidelines for relational schemas? why do we need functional dependencies? Explain 2NF, 3NF with suitable example.

Answer comingAlso asked in 2081
10
3.
Explain deadlock with example. What are different deadlock prevention protocols? Explain deadlock detection and starvation.

Answer coming
10

Attempt any EIGHT question.(8 × 5 = 40)

4.
What are the characteristics of database approach? Explain.

Answer coming
5
5.
Define data independence. Explain three-schema architecture.

Answer coming
5
6.
What is specialization? What are different constraints on specialization?

Answer comingAlso asked in 2081
5
7.
What is relational database? Explain different characteristic of a relation. Defain domain constraint.

Answer coming
5
8.
What is tuple realtion calculus ? Given the following schema, write tuple relational calculus for selecting name and address of employee who are working in a company having Cid=E01

Employee(Eid, Ename, Address, Cid)

Company(Cid, CName)

Answer coming
5
9.
Explain schedule based on recoverability and serializability.

Answer coming
5
10.
How timestamp ordering protocol is used for ensuring concurrency control?

Answer coming
5
11.
Why database recovery is essential? Explain recovery technique based on immediate update.

Answer comingAlso asked in 2080
5
12.
Write short notes on:
1. Transaction processing
2. Weak entity
Answer coming
5

— The End —