Database Management Systems-I Laboratory
Subject Overview
The practical companion to Database Management Systems-I, taking students from ER diagram design through the full SQL workflow — DDL table creation and modification, DML operations, constraints, transaction control, aggregate/grouping queries, analytical and recursive queries, operators, and all join types on a supplier/part/supplies schema. A 1-credit core lab paper.
Unit-wise Syllabus
1 units — click WhatsApp below to get the full notes for each
Unit 1: SQL from schema design to advanced queries
ER diagram design and table reduction, DDL commands (create/alter/drop/rename/truncate), DML commands (insert, select, filter, delete), queries with primary/foreign/unique/check/default constraints, TCL (savepoints, rollback, commit), aggregate functions (min/max/avg/sum/count), GROUP BY/HAVING/ORDER BY queries, analytical/hierarchical/recursive queries, comparison and pattern-matching operators, inner/natural/left/right/full outer joins