Database Management Systems Lab

LIST OF EXPERIMENTS

1. Study and practice various database management systems like MySQL/Oracle/PostgreSQL/SQL Server and others.

2. Implement simple queries of DDL and DML.

3. Implement basic queries to Create, Insert, Update, Delete and Select Statements for two different scenarios (For instance: Bank, College etc.)

4. Implement queries including various functions- mathematical, string, date etc.

5. Implement queries including Sorting, Grouping and Subqueries- like any, all, exists, not exists.

6. Implement queries including various Set operations (Union, Intersection, Except etc.).

7. Implement various JOIN operations- (Inner, Outer).

8. Write a PL/SQL program using FOR loop to insert ten rows into a database table.

9. Given the table EMPLOYEE (Emp No, Name, Salary, Designation, DeptID), write a cursor to select the five highest-paid employees from the table.

10. Illustrate how you can embed PL/SQL in a high-level host language such as C/Java And demonstrates how a banking debit transaction might be done.

The students should be motivated to make a project using MySql and MongoDb.