TRIBHUVAN UNIVERSITY
INSTITUTE OF SCIENCE AND TECHNOLOGY
2081 B.S.
Candidates are required to give their answers in their own words as far as practicable.
Group A
Long Answer QuestionsAttempt any Two questions.
- 1What 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.
- 2Consider 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".
- 3What are desirable properties of transactions? Explain conflict serializability with example.
Group B
Short Answer QuestionsAttempt any Eight questions.
- 4What do you mean by referential integrity? Why do you need this integrity?
- 5Explain ANSI/SPARC three-schema architecture with suitable diagram.
- 6What are informal design guidelines for relational schemas.
- 7Classify database management systems based on the data model.
- 8Define the terms data, database, DBMS, database system, and data base catalog.
- 9Explain relational algebra natural join ($*$) operation with example.
- 10Explain deferred update approach in database recovery.
- 11Explain transaction deadlock with example.
- 12Define specialization. Explain disjoint constrain with example.