Relational Database Management System Laboratory Notes
Subject Overview
The practical companion to Relational Database Management System, taking students through DDL/
Subject at a glance
1
Units
12
Topics
2
Credits
1
Infographics
Unit-wise Syllabus
1 units — open any unit for detailed topic-wise notes, diagrams and important exam questions
- 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
- a complete conceptual and relational data model design for a university database application
PRIMARY KEY
Unique and not null
FOREIGN KEY
Referential integrity
UNIQUE
No duplicate values
NOT NULL
Value required
CHECK
Custom rule, e.g. salary > 0
Study guide
In this lab you practise DDL, constraints (check, entity and referential integrity, unique, null), DML and DCL, built-in functions, nested and join queries, cursors, procedures, functions, triggers, embedded SQL, ER and normalisation-based design for payroll, banking and library systems and a full design for a university database. Design the schema on paper before writing SQL.
Why Relational Database Management System Laboratory Matters
A complete database design project is a strong portfolio item and direct interview material.
How to Prepare for Relational Database Management System Laboratory
- Design and implement one complete database end to end.
- Practise joins and subqueries with sample data.
- Test triggers and procedures with edge cases.
Relational Database Management System Laboratory: Frequently Asked Questions
What is built in the RDBMS lab?
Tables, constraints, queries, procedures and triggers, culminating in a university database design.