BCA 4th Semester
Database Management System Board Question Paper 2022

Views: ...
tribhuvan university logo

Tribhuvan university

Bachelor In Computer Application

Course Title: Database Management System

Code No: CACS 255

Semester:IV

2022

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 advantages and disadvantages of using DBMS.

3.

Describe 3-schema architecture of database.

4.

What are roles and responsibilities of DBA.

5.

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

6.

What are the states of transaction model? Describe the ACID properties of transaction.

7.

Describe the use of ER diagram. Draw an ER diagram for a university to design a database for it.

8.

What is DDL and DML queries?
Consider the following relation.

Customer nameLoan number
XL01
YL02
Relation borrower
Loan numberBranch nameAmount
L01B15000
L02B26000
Relation loan
Write a relational algebra expression to find all customer who taken loan from branch "B1".

Group C

Attempt any TWO questions

[2x10=20]
9.

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

10.

Differentiate between stored procedure and trigger. Why concurrency control is needed? Describe timestamp based concurrency protocol.

11.

What is data model? What are its types? Describe the structure of database.