Database Management System (CSC265) 2081 BS Past Questions & Solutions

Tribhuvan University (TU) 2081 BS board exam question paper with verified step-by-step solutions for BSc CSIT Fourth Semester.

TRIBHUVAN UNIVERSITY

INSTITUTE OF SCIENCE AND TECHNOLOGY

2081 B.S.

Bachelor Level: B.Sc. CSIT

Semester: Fourth Semester

Subject: Database Management System (CSC265)

Full Marks: 60 / 80

Pass Marks: 24 / 32

Candidates are required to give their answers in their own words as far as practicable.

Group A

Long Answer Questions

Attempt any Two questions.

  1. 1
    What do you mean by entity type and entity set? Construct an ER diagram for an airline ticket booking system where customers buy airline tickets online. The system should provide discounts on the basis of number of tickets bought. It should also keep records of buyers on the basis of number of times buyer visits the system. It should also filter the unwanted visitors to manage traffic congestion.
  2. 2
    Consider the library database schema containing the tables given below where primary keys are underlined. USER (UserID, User_name, Address) USES (UserID, BookID, Issued_date, Returned_date) BOOK (BookID, Book_name, Author, PublisherID) PUBLISHER (PublisherID, Publisher_name, Address) Specify the following queries in both SQL and Relational Algebra on this database schema. a. Retrieve names of all books issued to the user "Hari". b. Retrieve the names of all books published by "ABC publication". c. Count the number of books published by the author "Ram".
  3. 3
    What are desirable properties of transactions? Explain conflict serializability with example.

Group B

Short Answer Questions

Attempt any Eight questions.

  1. 4
    What do you mean by referential integrity? Why do you need this integrity?
  2. 5
    Explain ANSI/SPARC three-schema architecture with suitable diagram.
  3. 6
    What are informal design guidelines for relational schemas.
  4. 7
    Classify database management systems based on the data model.
  5. 8
    Define the terms data, database, DBMS, database system, and data base catalog.
  6. 9
    Explain relational algebra natural join ($*$) operation with example.
  7. 10
    Explain deferred update approach in database recovery.
  8. 11
    Explain transaction deadlock with example.
  9. 12
    Define specialization. Explain disjoint constrain with example.