MCASemester 22021-22Database Management SystemsKCA-204

Database Management Systems (KCA-204) - AKTU Question Paper 2021-22

MCA · Semester 2 · Free PDF Download

This is the official AKTU Database Management Systems Previous Year Question Paper for MCA Semester 2, academic session 2021-22. Published by Dr. A.P.J. Abdul Kalam Technical University (AKTU/UPTU), Lucknow. Free PDF download — no login required.

Course:MCA

Semester:Semester 2

Session:2021-22

University:AKTU / UPTU

Rate this paper

Questions Asked in 2021-22

Database Management Systems (KCA-204) — complete question paper

Section AAttempt all q u e s t i o n s i n b r i e f . 2*10 = 20

a
What do you mean by logical data independence? 1
b
What do you mean by domain integrity? 1
c
Define entity and entity set. 2
d
Explain with suitable example: Simple – Composite Attribute. 2
e
Determine the Relational Al gebra expression for following- For a relation Employee(EID, Ename, city), find the name of employees who either live in Delhi or live in Mumbai
f
There is a table named CUSTOMER (ID, Name, DOR). Write the sql query to display all the customer details. ( Note – Early Date of registration must be displayed first)
g
What will be the possible superkeys for the relation schema R(E,F,G,H) with EF as key ?
h
Consider a relation R (A, B, C, D, E) with following FD’s: Does B -> CD? Exists over the relation R? (i) “A transaction must follow Durability property” . What do you mean by Durability? (j) There is a schedule S having 5 transactions. How many serial schedules can be made possible?

Section BAttempt any three o f t h e f o l l o w i n g : 10*3 = 30

a
“Data redundancy leads to data inconsistency”. Justify your answer
b
Explain participation constr aint in E-R diagram with a suit able example
c
Write the SQL command to Create the table named STUDENT Column Name Data Type Size Remark Roll Number 5 Primary Key, must start with Name Varchar2 25 Null values are not allowed DOB Date Email Varchar2 30 Must take unique values only DOR Date Must not less than DOB

Suppose a relational schema R (P, Q, R, S), and set of functional

dependency as following
 F: {P -> QR, Q -> R, P-> Q, PQ -> R}
Find the canonical cover Fc

e
What is system log? What are the record entries done into the s ystem log during execution of a transaction?

Section CAttempt any one p a r t o f t h e f o l l o w i n g : 10*1 = 10

a
With a neat diagram discuss the three-level architecture of DBMS 1
b
What are the advantages of Database over file system? 1
a
Consider the assumptions
a
Employee works for a department
b
In one department there are many employees
c
Each employee have some dependents
d
Employee works in some projects Considering the above assumptions, draw an E‐R Diagram. Convert the diagram to Relational Model
b
A relation named STUDENT(Roll, Name, DOB, Address, AdharNo, Email) is there. Find out the following
c
Non‐Prime attributes
a
How a trigger is different from procedure? What are the uses of a trigger? Write a trigger which will insert the updated salary, the old salary of an employee along with the date of updation into a ta ble named Employee_Backup
b
Find out the tables named EMP(Id, Name, DOJ, DeptID, Salary), Dept(DeptId, Name, Location) Write the SQL query for the following
a
Display the employee details along with the department name where the employee is working
b
Display the employees according to date of joining. (Recent joins should come first)
c
Display the number of employees working in \MCA Department
d
Display the employee names whose name starts with ‘Ra’
e
Display the employees who are getting more salary than what ‘Rohan’ is getting
a
What do you mean by lose-less decomposition of a relation? Consider the relational scheme R (A,B,C,D,E,F) and FDs Is the decomposition of R into R1 (A, C, D), R2 (B, C, D) and R 3 (E, F, D) lossless?
b
What is partial functional dependency? Explain how insertion anamoly, updation anamoly and deletion anamoly occurs when a relation is having partial dependency?
a
What do you mean by concurrency control? What is a timestamp? Discuss basic timestamp and strict timestamp protocol as concurrency control mechanism
b
How serial schedule is different from non-serial schedule? What is a serializable schedule? A schedule is given as follows Check whether schedule S is a conflict serializable schedule or not?

Question text is extracted from the official AKTU question paper PDF above. Hindi translations are omitted — every question is printed in English in the original paper. Last verified: 2026-08-23.

Repeated Questions — KCA-204

Questions that appeared in more than one session, found by comparing 4 years of Database Management Systems papers (2021-22, 2022-23, 2023-24, 2024-25)

What do you mean by logical data independence? 1