Database Management Systems-I Laboratory Notes
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/
Subject at a glance
1
Units
10
Topics
1
Credits
1
Infographics
Unit-wise Syllabus
1 units — open any unit for detailed topic-wise notes, diagrams and important exam questions
- 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
INNER JOIN
Only matching rows from both tables
Customers who placed orders
LEFT JOIN
All left rows plus matches
All customers, with orders if any
RIGHT JOIN
All right rows plus matches
All orders, with customer if any
FULL OUTER JOIN
All rows from both tables
Complete reconciliation of two lists
Study guide
In the DBMS lab you practise SQL from design to advanced queries: designing an ER diagram and reducing it to tables, DDL (create, alter, drop, rename, truncate), DML (insert, select, filter, delete), constraints (primary, foreign, unique, check, default), TCL (savepoint, rollback, commit), aggregate functions, GROUP BY, HAVING and ORDER BY, analytical, hierarchical and recursive queries, comparison and pattern-matching operators, and inner, natural and left, right and full outer joins. Run every query and read the output carefully to confirm it answers the question asked.
Why Database Management Systems-I Laboratory Matters
Writing SQL against real tables is the single most employable skill in this subject, and these are the query types asked in interviews and practical exams.
How to Prepare for Database Management Systems-I Laboratory
- Practise each query type on a sample database with your own data.
- Learn the difference between the join types by running each on the same two tables.
- Keep a record of every query with its output.
Database Management Systems-I Laboratory: Frequently Asked Questions
What queries are asked in the DBMS lab?
DDL and DML commands, constraints, aggregate functions with GROUP BY and HAVING, joins, TCL commands and analytical or recursive queries.