Database Management System Lab

List of Experiments

1. Experiments based on DDL commands – CREATE, ALTER, DROP and TRUNCATE.
2. Apply the integrity constraints like Primary Key, Foreign key, Check, NOT NULL, etc. to the tables.
3. Experiments based on basic DML commands – SELECT, INSERT, UPDATE and DELETE.
4. Write the queries for implementing Built-in functions, GROUP BY, HAVING and ORDER BY.
5. Write the queries to implement the joins.
6. Write the queries to implement the subqueries.
7. Write the queries to implement the set operations.
8. Write the queries to create the views and queries based on views.
9. Demonstrate the concept of Control Structures.
10. Demonstrate the concept of Exception Handling.
11. Demonstrate the concept of Functions and Procedures.
12. Demonstrate the concept of Triggers.