BCA Database Management System

bcasemester 4

This course offers both theoretical as well as practical knowledge of database management system so that students can handle back end of software while developing any types of application packages.

Chapter Wise Notes Question Banks Syllabus Chapter Wise Questions Viva Practical

Faculty of Humanities and Social Sciences

2026

Bachelor of Computer Application

Database Management System

CACS255

Full Marks: 60

Pass Marks: 24

Candidates are required to give their answers in their own words as far as practicable. The figures in the margin indicate full marks.

"Group B"

Attempt any SIX questions.

[6 × 5 = 30]

Define transaction. Describe ACID properties with example.

[1 + 4]

Explain physical data independence and logical data independence.

[2.5 + 2.5]

What is stored procedure? Describe statement level trigger and multi row enabled triger?

[1 + 4]

Define schedule and serializability with example. How can you test the serializability?

[2 + 3]

What is data model? What are its types?

[1 + 4]

Define query processing and steps in query processing.

[1 + 4]

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

[5]

"Group C"

Attempt any TWO questions.

[2 × 10 = 20]

Describe DDL and DML queries with example. Explain database system architecture.

[3 + 7]

What is normalization? What are its advantages? Describe its types with appropriate examples.

[2 + 2 + 6]

Consider the following schema:

Guest (Gid, Gname, Age, Gender

STAFF (Sid, Sname, Age, Gender, Roles

SERVICE (serId, serName, Price)

ASSISTS (Gid, Sid) (Which staff assists which guest)

PROVIDES (serId, Sid) (Which staff provides which service)

Write SQL Queries:

a) Find name of guests who are VIP.

b) Find total number of guests assisted by staff Ram.

c) Find name of staff whose name starts with A and ends with A.

d) Display name of staff who provides laundary service.

e) Give 10% discount to female guests on the price of service they receive.

[3 + 2 + 2 + 1 + 2]

BCA Database Management System

BCA Semester 4 Database Management System Question Paper 2026 (TU) – Solved

Faculty of Humanities and Social Sciences