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

CSC 265-2082 ✡
Tribhuvan University
Institute of Science and Technology
2082
✡
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.

Consider the following database schema, where primary keys are underlined.
EMPLOYEE(EmployeeID, FirstName, LastName, DepartmentID, Salary, HireDate)
DEPARTMENT(DepartmentID, DepartmentName)
PROJECT(ProjectID, ProjectName, StartDate, EndDate, DepartmentID)
Specify the following queries on this database schema.
a. Write SQL queries to create three tables in the database with primary key, foreign key, and referential integrity.
b. Write both SQL and relational algebra query to retrieve first name and last name of all employees along with their department names.
c. Write SQL query to count the number of employees in each department.

2.

How do you convert ER diagram to relations? Explain 1NF and 3NF with suitable examples.

3.

Why do you need concurrency control in databases? Explain lost update problem, unrepeatable read problem, and incorrect summary problem with example.

Section B

Attempt any Eight questions

[8x5=40]
4.

List characteristics of database approach. What are the advantages of using database approach?

5.

Define datamodel. What are different categories of datamodels?

6.

Explain three schema architecture in detail. What do you mean by data independence?

7.

Draw an ER diagram for a hotel reservation system including rooms, guests, and bookings.

8.

Define specialization. Explain constraints and characteristics of specialization and generalization.

9.

Define the terms domain, attribute, tuple, and relation. What is entity integrity constraint?

10.

Explain desirable properties of transactions.

11.

Explain two-phase locking technique. What is lock conversion in this technique?

12.

What is write ahead logging in database recovery? What is checkpoint?