Relational Database Management System
Subject Overview
Relational Database Management System covers database fundamentals and the relational model, the full SQL language (DDL/DML/DCL, joins, views, triggers, stored procedures), database design via the ER model and normalization through 5NF/DKNF, and transaction management including query processing, concurrency control, security and recovery. A 4-credit core theory paper.
Unit-wise Syllabus
4 units — click WhatsApp below to get the full notes for each
Unit 1: Database and RDBMS fundamentals
Purpose and applications of database systems, DBMS fundamentals (data view, database languages, design, storage and querying, transaction management, architecture), RDBMS fundamentals — structure of relational databases, schema, keys, relational query languages and operations
Unit 2: SQL
DCL/DDL/DML, SQL data definition, basic query structure, set operations, null values, aggregate functions, nested subqueries, database modification, join expressions, views, transactions, integrity constraints, SQL data types and schemas, authorization, functions/procedures/triggers, introduction to embedded SQL, dynamic SQL, JDBC and SQLJ
Unit 3: Database design and normalization
The Entity-Relationship model and ER diagrams, features of good relational design, atomic domains and 1NF, functional dependency and 2NF, transitive dependency and 3NF, BCNF, multivalued dependency and 4NF, join dependency and 5NF, domain-key normal form
Unit 4: Transaction management
Query processing, concurrency control, database security, database recovery