RDBMS Syllabus — Government College of Engineering and Technology, Ja…
Full syllabus, topics and curated resources for RDBMS (Government College of Engineering and Technology, Jammu).
Database management systems, entity relationship models, relational models, SQL, normalization, indexing, transactions, concurrency control and recovery
- Subject code: CST3402
- University: Government College of Engineering and Technology, Jammu
- Course: BE (2022 onwards)
- Branch: CE
- Semester: 4
RDBMS syllabus
Unit 1: Database Concepts and ER Model
- Database and DBMS
- Database Systems versus File Systems
- Data Abstraction
- Instances, Schemas and States
- Data Models
- Database Languages
- Database Users and Administrators
- Advantages and Disadvantages of DBMS
- Entity Relationship Model
- ER Diagram
- Weak Entity Sets
- Extended ER Features
- ER Schema Design
- Reduction of ER Schema to Tables
Unit 2: Relational Model and Database Design
- Attributes and Domains
- Tuples, Relations and Schemas
- Relation Representation
- Keys and Integrity Rules
- Relational Algebra
- Relational Calculus
- SQL Data Manipulation
- Normalization Using Functional Dependency
- Normalization Using Join Dependencies
- Domain Key Normal Form
Unit 3: Indexing and Transactions
- Indexing Concepts
- Primary and Secondary Indices
- B+ Tree Index Files
- B-Tree Index Files
- Transaction Concept
- Atomicity and Durability
- Concurrent Executions
- Serializability
- Recoverability
- Isolation