Database Management System (BCS403) Question Bank
MODULE-2
Relational Model, Mapping Conceptual Design into a Logical Design
Q.
Question COs CL Marks
No.
1. Define the following: i) Relation ii) Domain iii) Relation State iv) Arity CO2 L1 6M
(Feb 2022,Jan 2019)
2. Describe the characteristics of relations with suitable example for each. CO2 L2 8M
(Jan 2019) (June2025)(July2025)
Or
Discuss the characteristics of relations that make them different from
ordinary table and files.(June 2024)
3. Explain relational model constraints. (June 2025) CO2 L2 6M
Or
Explain the four relational model constraints.( Jan2024)
4. What is meant by Integrity Constraint? Explain the importance of referential CO2 L2 8M
integrity constraint. How referential integrity is implemented in SQL? (June
2025)
5. Discuss the update operations and dealing with constraint violations with CO2 L2 8M
suitable examples.(June 2024)
6. Briefly explain different types of update operation in relation database. Show CO2 L2 10M
an example of violation of referential and entity integrity in each of the
update operation.(July 2024)
7. Briefly explain violations in Entity integrity constraint, Key and referential CO2 L2 10M
integrity constraints, with example. (July 2025,Feb 2022, July 2018)
8. Explain the ER to relational mapping algorithm with suitable example and CO2 L2 10M
schema for each step. (July 2025,June 2025,July 2024,Jan2024,Feb 2022,
Feb 2021)
9. Explain with example: CO2 L2 10M
i)Division operator ii) Full outer join iii)Aggregate function
Department of AI&ML, Vemana IT Page 1 of 6
Database Management System (BCS403) Question Bank
iv)Project operation v)Cartesian product
10. Define the following terms with example. i) Primary Key ii) Super Key CO2 L1 8M
iii) Foreign Key iv) Candidate Key (June 2023,Feb 2022,Jan 2020)
11. Explain Unary relational operations with example.(June 2024,july 2025) CO2 L2 6M
12. Illustrate the relational algebra operators with examples for select and project CO2 L2 6M
operation.(June 2025)
13. Explain all types of outer join operations in relation algebra. Demonstrate the CO2 L2 6M
advantages of outer join operations over the inner join operations. (Jan
2024)
14. Consider the following schema (July 2024) CO2 L3 10M
Suppliers(sid,sname,address)
Parts(pid, pname,color)
Catalog(sid,pid,price)
Write a relational algebra queries for the following.
i. Find the names of all red parts
ii. Find the prices of parts that were red or green.
iii. Find the sid’s of all suppliers who supply part is red or green.
iv. Find the sid’s of all suppliers who supply part is red and green.
15. Consider the following schema Employee database CO2 L3 8M
EMPLOYEE(Fname,Minit,Lname,Ssn,Bdates,Address,gender,Salary,Super_
SSn, dno)
DEPARTMENT(Dname,Dno,Mgr_ssn,Mgr_start_date)
PROJECT(Pname,PNumber,Plocation,Dnum)
WORKS_ON(Essn,Pno,Hours)
DEPENDENT(Essn,Dependent_name,gender,Bdate,Relationship)
Write relational algebra queries for the following:
i. Retrieve the name and address of all employees who work for the
‘Research’ department.
ii. List the names of employees with 2 or more dependents.
iii. Find the names of employees who work on all the projects
controlled by department number 5.
iv. List the names of employees who have no dependents.
16. Consider the following relational database schema and write the queries in
relational algebra expressions: (July2025)
Department of AI&ML, Vemana IT Page 2 of 6
Database Management System (BCS403) Question Bank
EMP (Fname, Lname, ssn, Address, DNo,Salary)
DEPT (Dno, Dname, MgrSSN)
D_LOC(Dno,Loc)
PROJECT(Pname,Pno,Dno,Ploc)
WORKS_ON(Essn,Pno,Hours)
i. Display the ssn,firstname and lastname of the employee working
for department no 5
ii. Retrieve the location of the ‘Accounts’ department.
iii. Select the tuples for all Employees who either work in department
4 and make over $25000 per year or work in department 5 and
make over $30000.
iv. Retrieve the names of the project controlled by department no 5
v. Retrieve the names of employees working on project no 8.
17. Consider the following relational database schema and write the queries in CO2 L3 10M
relational algebra expressions:
EMP (Eno, Ename, Salary, Address, Phone, DNo)
DEPT (DNo, Dname, Dloc, MgrEno)
DEPENDENT (Eno, Dept_Name, Drelation, Dage)
i) List all the employees who reside ‘Belgavi’
ii) List all the employees who earn salary between 30000 and 40000
iii) List all the employees who work for the ‘Sales’ department.
iv) List all the employees who have atleast one daughter
v) List the department names along with the names of the managers.
(June 2024)
18. Consider the following relation schema: CO2 L3 7M
Works(Pname,Cname,salary)
Lives(Pname,Street,City)
located_in (Cname, city)
Solve the following queries in Relational algebra:
i) List the names of the people who work for the company ‘Wipro’ along
with the cities they live in.
ii)Find the names of the persons who do not work for the company
"Infosys" .
iii) Find the people whose salaries are more than that of all of the ‘oracle’
Department of AI&ML, Vemana IT Page 3 of 6
Database Management System (BCS403) Question Bank
employees .
iv)Find the persons who works and lives in the same city.
v)Find the names of the companies that are located in every city where the
company Infosys is located.
(July2023)
19. Consider the following schema (June2025) CO2 L3 10M
Sailors(sid,sname,rating,age)
Boats(bid, bname,color)
Reserves(sid,bid,day)
Write a relational algebra queries for the following.
i. Find the names of sailors who have reserved boat #103
ii. Find the names of sailors who have reserved a red boat.
iii. Find the names of sailors who have reserved a red boat and green
boat
iv. Find the names of sailors who have reserved a red boat or green
boat
v. Find the names of sailors who have reserved all boats.
20. Consider Two tables T1 and T2. Evaluate the results of the following
operations:
T1: T2:
P Q R
A B C
10 b 6
25 c 3
10 b 5
10 a 5
15 b 8
25 a 6
i) T1 ∞ T1.P = T2.A T2
ii) T1 ∞ T1.Q = T2.BT2
iii) T1 ∞ T1.R = T2.C T2
iv) T1 ∞( T1.P = T2.A AND T1.Q=T2.R) T2
Department of AI&ML, Vemana IT Page 4 of 6
Database Management System (BCS403) Question Bank
21. Discuss the Division operation of relational algebra. CO2 L2 8M
Find the quotient for the following.
Find i) A/B1 ii) A/B2 iii)A/B3
PNO PNO
A: SNO DNO B1: P2 P2
S1 P1
S1 P2 P4
S1 P3 PNO
S1 P4
S2 P1 P1
S2 P2 P2
S3 P3
S4 P2 P4
S4 P4
22. Perform CO2 L3 4M
i) Student U instructor ii) Student ∩ instructor
iii) Student-Instructor iv) Instructor –Student on the following
tables.(July 2024)
Student Instructor
Fname Lname Fname Lname
Susan Yao John Smith
Ramesh Shah Ricardo Browne
Johny Kohler Susan Yao
Barbara Jones Francis Johnson
Amy Ford Ramesh Shah
Jimmy Wang
Ernest Gilbert
Department of AI&ML, Vemana IT Page 5 of 6
Database Management System (BCS403) Question Bank
Course Faculty
Lakshmi Sravani G
Department of AI&ML, Vemana IT Page 6 of 6