IT405 Unit 2
Database Management System

Relational Model & ER Model

Unit 2 Study Material

Download detailed notes, important questions and PYQ analysis for IT405 Database Management System Unit 2.

🧩 Relations

Tables store data using rows and columns in relational databases.

🔑 Keys

Keys uniquely identify records and create relationships between tables.

📊 ER Model

ER diagrams help design databases using entities and relationships.

📘

Detailed Notes

Complete notes on relational model, domains, relations, relational algebra, ER model, constraints, keys, weak entities and extended ER features.

Download PDF
⭐

Important Questions

Important RGPV questions on relational algebra, ER model, keys, constraints, weak entity sets, generalization, specialization and aggregation.

View Questions
📄

PYQ Analysis

Previous year questions and repeated topics from Database Management System Unit 2 for quick exam revision.

Open Analysis

Unit 2 Topics

Structure of Relational Databases
Domains
Relations
Tuples
Attributes
Relational Algebra
Fundamental Operators
Selection Operator
Projection Operator
Union Operator
Set Difference
Cartesian Product
Rename Operator
Relational Algebra Queries
Entity Relationship Model
Basic ER Concepts
Database Design Process
Constraints
Keys
Primary Key
Candidate Key
Foreign Key
Design Issues
ER Diagrams
Weak Entity Sets
Extended ER Features
Generalization
Specialization
Aggregation