BCA 4th Semester
Database Management System Board Question Paper 2020

Views: ...
tribhuvan university logo

Tribhuvan university

Bachelor In Computer Application

Course Title: Database Management System

Code No: CACS 255

Semester:IV

2020

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

Candidates are required to answer the question in their own words as far as possible.

Group A
Group B
Attempt any SIX question.
[6x5=30]
2.

What is DBMS? Describe the merits of using DBMS.

3.

What is Data Model? What is the difference between hierarchical and network data model? what are its types?

4.

Why indexing is essential in database? Differentiate dense index from sparse index with suitable example.

5.

Discuss about materialized and pipelined evaluation of query expression in query optimization.

6.

Explain with examples, how lost update and dirty read problems can occur in sentence of transactions?

7.

How time stamp ordering protocol is used to ensure concurrency control?

8.

What is the advantage and Disadvantage of using stored procedure? How can you create and execute stored procedure?

Group C

Attempt any TWO questions

[2x10=20]
9.

Design an ER diagram for Hospital System. Use your assumption for the selection attributes, entities and relationships. Show the use of total and partial participation along with the appropriate cardinalities.

10.

Discuss the importance of normalization in DBMS. Describe 1NF, 2NF and 3NF with examples.

11.

Consider a database system with following schemes:
    Restaurant(Rname, Rlocation, Rfund)
    Cook(Cname, Cspeciality)
    Worksat(Cname, Rname, Workinghrs, Shift)
    Food(Fname, Cname, Catagory)
Now write SQL statements and relational algebra statements for following Queries:
a) Select the name and location of all restaurants.
b) Find the working hours of cook named "Sita".
c) Select name of the foods cooked by "Ramesh".
d) Use join to select name of restaurants where food of category "breakfast" is available.
e) Find the name of cooks who work as "KFC"