BBA 2nd Semester
Database Management System Board Question Paper 2025

Mention any one difference between schemas and instances.

Define attribute inheritance.

List out any two data types used in SQL.

What is the importance of creating role?

Define Transitive dependency.

Write SQL query to remove an attribute named 'email' from Employee table.

Define concurrent transaction.

Define distributed databases.

Define privileges in database management.

What is catastrophic failure?

Write about any three types of constraints used in database.

Differentiate between deferred update and immediate update.

Illustrate and explain three-schema architecture.

Mention any three methods to make database secure.

Explain the types of relationship set.

Explain the desirable properties of transactions.

Define concurrency control. Describe about two phase locking protocol for concurrent
transaction.

Explain the concept of specialization with your own example.

Explain the types of Anamolies.

Illustrate and explain two tier and three tier database application architecture.

Consider the following tables of a database:
Instructor (InstructorID, InstructorName, JobStatus)
Subject (SubCode, SubjectName, CreditHours)
Taught (Subcode, InstructorID, Semester)
Write SQL Queries for the following:
i) Insert a record with values “IT232”, “DBMS”, 3 in the Subject table
ii) Change the JobStatus of an Instructor with ID 521 to ‘Permanent’
iii) To add a column “salary” in instructor table.
iv) To display the name of instructor with highest salary.
v) To delete a column credit hours from subject table.

Normalize the following relation up to 3-NF.