PAAVAI ENGINEERING COLLEGE

DEPARTMENT OF INFORMATION TECHNOLOGY

COMMON TO IT, CSE, AIML

S.No Question Bloom’s Level Marks

1 Define Relational Algebra. Remember 2
2 What is Tuple Relational Calculus? Remember 2
3 Define Domain Relational Calculus. Remember 2
4 List any two operations in Relational Algebra. Remember 2
5 What is the significance of constraints in the E-R model? Understand 2
6 Define Entity and Relationship with an example. Remember 2
7 What are Redundant Attributes in Entity Sets? Understand 2
8 Define Cardinality and Participation in the E-R Model. Remember 2
9 Differentiate between Strong and Weak Entities. Understand 2
10 What is a Derived Attribute in the E-R Model? Remember 2
11 List any two advantages of the Relational Model. Understand 2
12 What is a Super Key in a Relation? Remember 2
13 What is a Foreign Key? Remember 2
14 Define Entity-Relationship Diagram (ERD). Remember 2
15 What are the different types of Relationships in the E-R Model? Understand 2
16 Define Aggregation in the E-R Model. Remember 2
17 What are the major components of an ER Diagram? Understand 2
18 What is Generalization and Specialization in E-R Diagrams? Understand 2
Differentiate between Tuple Relational Calculus and Domain 2
19 Understand
Relational Calculus.
20 What is Projection in Relational Algebra? Remember 2
21 What is Selection in Relational Algebra? Remember 2
22 Define Union Operation in Relational Algebra. Remember 2
23 What is an Attribute in the Relational Model? Remember 2
24 How will you apply a Candidate Key? Give example Apply 2
Where and how will you use the different types of attributes in an 2
25 Analysis
entity set?
S.No Question Bloom’s Level Marks
1 A university maintains a database for student records, including Analysis
student details, course enrollment, and grades. Design an ER model for 12
the university, define relationships, constraints, and justify
normalization techniques to avoid redundant attributes.
2 A company uses relational databases to store employee information, Apply 12
department details, and project assignments. Write relational algebra
queries to retrieve employees working on a specific project, employees
in a given department, and employees who have not been assigned any
project.
3 A hospital database maintains patient records, doctor details, and Apply 12
treatment histories. Formulate tuple relational calculus and domain
relational calculus queries to retrieve patients treated by a specific
doctor and patients with a specific diagnosis.
4 A bank database contains customer information, account details, and Analysis 13
 transaction history. Identify and resolve entity redundancy issues in the
database and propose modifications to improve efficiency while
maintaining integrity constraints.
5 A library maintains records of books, authors, and borrowers. Analysis 13
Construct an ER diagram and define the relationship constraints
between books and authors, books and borrowers, and fine calculation
for late return.
6 A multinational corporation has multiple branches worldwide, with Analysis 13
centralized and distributed databases. Analysis the challenges in ER
design for such an organization, suggest an optimal model, and justify
your approach.
7 A government organization stores citizen details, tax records, and Analysis 13
property ownership. Propose an ER model with relevant attributes,
relationships, and constraints, ensuring data consistency and
eliminating redundancy.
8 A railway reservation system keeps track of passengers, train Apply 13
schedules, and bookings. Design relational algebra expressions to
retrieve available trains for a given route, ticket reservations for a
passenger, and waiting list status updates.
S.No Question Bloom’s Level Marks
1 Define Relational Algebra and explain its fundamental operations with Remember 6
examples.
2 Describe Tuple Relational Calculus and compare it with Relational Understand 6
Algebra.
3 Illustrate Domain Relational Calculus with suitable examples. Understand 6
4 Explain the significance of the Entity-Relationship (E-R) model in Understand 6
database design.
5 Discuss various types of constraints in the E-R model with examples. Understand 7
6 Consider a banking database with attributes (Account_No, Name, Apply 7
Balance). Write Relational Algebra queries to retrieve: (i) All account
numbers with balance greater than 10,000. (ii) Names of account
holders with balance less than 5,000.
7 Construct Tuple Relational Calculus expressions for retrieving students Apply 7
who have scored above 80 marks in a student database (Student_ID,
Name, Marks).
8 Given an Employee database (Emp_ID, Name, Department, Salary), Apply 7
formulate a Domain Relational Calculus query to find employees
earning more than 50,000.
9 Analysis how redundant attributes in entity sets can affect database Analysis 6
normalization.
10 Identify common design issues in E-R modeling and suggest ways to Analysis 6
resolve them.
11 Compare and contrast Tuple Relational Calculus and Domain Analysis 6
Relational Calculus in terms of expressiveness and ease of use.
12 Evaluate the advantages and limitations of using Relational Algebra Analysis 6
over other query languages.