Database_Management_Systems_CSE2004

Database Management Systems - CSE2004

Setup

The labs in this section cover Database management systems, and we use mysql for the earlier labs and mssql when dealing with procedures, etc. Use any guide online for installing the sql server and configure it.

List of Programs

1. SQL - DDL and DML

S.no	Name of the Experiment
1	Study DDL and DML commands

2. SQL - Queries and Constraints

S.no	Name of the Experiment
1	Library

3. SQL - Query Operators

S.no	Name of the Experiment
1	Boat Management

4. SQL - Joins

S.no	Name of the Experiment
1	Event Management

5. SQL - Queries I

S.no	Name of the Experiment
1	Employees Management

6. SQL - Queries II

S.no	Name of the Experiment
1	Airline Flight Management

7. Procedural SQL

S.no	Name of the Experiment
1	Even / Odd Number
2	Armstrong Number
3	Factorial
4	Palindrome

8. PL-SQL Cursors

S.no	Name of the Experiment
1	Cursors

9. PL-SQL Nested Cursors

S.no	Name of the Experiment
1	Examination Achievers
2	Employee Management - Loops
3	Employee Management - Nested Loops

10. SQL Views

S.no	Name of the Experiment
1	Views

11. PL-SQL Procedures

S.no	Name of the Experiment
1	Procedures