DBMS Lab
DBMS Lab
Computer Science & Engineering
Overview
This laboratory is intended to practice the concepts of Database Management Systems. Students develop schema designs, write SQL queries, design forms and reports, and apply all relevant concepts learned in theory to perform real operations on databases.
Expected Outcomes
- Design database schemas using Entity-Relationship diagrams.
- Write complex SQL queries for data definition, manipulation, and control.
- Implement database integrity constraints, views, and indexes.
- Write PL/SQL blocks, procedures, functions, and triggers.