CS-504 (C) RGPV B.Tech
Introduction to Database Management Systems (IDMS)
Previous year papers and the official syllabus are free to read, no account needed.
Previous Year Papers
1 paper, latest Dec 2025
Syllabus, notes and important questions for CS-504 (C)
- Syllabus Official RGPV syllabus Free
- Notes 5 documents Free
- Important Questions None for CS-504 (C) yet
Syllabus units
Topics as the official RGPV syllabus lists them.
Unit 1 Database Management System Concepts 11 topics
- Introduction
- Significance of Database
- Database System Applications
- Data Independence
- Data Modeling for a Database
- Entities and their Attributes
- Entities
- Attributes
- Relationships and Relationship Types
- Advantages and Disadvantages of Database Management System
- DBMS Vs RDBMS
Unit 2 Database Models and Implementation 11 topics
- Data Model and Types of Data Model
- Relational Data Model
- Hierarchical Model
- Network Data Model
- Object/Relational Model
- Object-Oriented Model
- Entity-Relationship Model
- Modeling using E-R Diagrams
- Notation used in E-R Model
- Relationships and Relationship Types
- Associative Database Model
Unit 3 SQL 10 topics
- Data Definition Language
- Categories of SQL Commands
- Create table
- Drop table
- Alter Table
- Primary Key
- Foreign Key
- Truncate Table
- Index
- Cursor
Unit 4 SQL DML 8 topics
- Data Manipulation Language
- Insert Statement
- Multiple Inserts
- Delete Statement
- Delete with conditions
- Update statement
- Update with Conditions
- Merge Statement
Unit 5 SELECT 19 topics
- SQL queries
- Data extraction from single tables
- Data extraction from multiple tables
- Equi-join
- Non equi-join
- Self-join
- Outer join
- Usage of LIKE
- ANY operator
- ALL operator
- EXISTS operator
- IN operator
- Hierarchical queries
- Inline queries
- Flashback queries
- Introduction of ANSI SQL
- Anonymous block
- Nested anonymous block
- Branching and looping constructs in ANSI SQL