Relational Database Management System Laboratory
Subject Overview
The practical companion to Relational Database Management System, taking students through DDL/DML/DCL command implementation, all constraint types, nested and join queries, cursors, procedures, functions and triggers, embedded SQL, and full database design (ER modeling and normalization) for payroll, banking, library and university management systems. A 2-credit core lab paper.
Unit-wise Syllabus
1 units — click WhatsApp below to get the full notes for each
Unit 1: SQL implementation and database design
DDL commands for table creation/alteration/modification/drop, constraint implementation (check, entity integrity, referential integrity, unique, null value), DML and DCL commands, built-in functions, nested and join queries, cursors, procedures and functions, triggers, embedded SQL, ER-model and normalization-based design for payroll, banking and library management systems, and a complete conceptual and relational data model design for a university database application