DBMS Model Question - With Solution

Tribhuvan University

Institute of Science and Technology

DBMS-Model-Question

Bachelor Level / fourth-semester / Science

Computer Science and Information Technology( CSC265 )

Database Management System

Full Marks: 60 + 20 + 20

Pass Marks: 24 + 8 + 8

Time: 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.

Section A

Attempt any two questions.

Consider the following database and write SQL as given:

Customer (Cno, Cname, Caddress, Ccontact)

Purchase (Cno, Pid)

Product (Pid, Pname, price, quantity)

a. Find the names of all products having price 1000.

b. Find the name of those customers who purchased Dell Laptop

c. Find the total number of products purchased by customer ‘Ram’

d. Increase price of all products by 5%

e. Find total price of Apple Mobiles.

What are the benefits of using normalization? Discuss 1NF, 2NF, and 3NF with suitable example.

Define Relational Algebra and explain its six fundamental operations with suitable example.

Section B

Attempt any eight questions.

What is database schema? What are functions of database administrator?

Construct an E-R diagram for online course registration where students register courses online.

Discuss referential integrity with example.

What is functional dependency? Why do we need inference rules?

Why do we need concurrency control? Discuss two phase locking protocol.

Why do we need database recovery? Discuss shadow paging technique for database recovery.

Differentiate concept of Centralized and Client/Server Architectures for DBMSs with suitable example.

Define Transaction and explain its desirable properties.

Explain constraints and characteristics of specialization and generalization of data model.