The main purpose of the Lab report is to build a student Information system and pay roll processing system to facilitate easy access of records of students across departments and the pay roll information of the employee. The Database System will allow the following activities like to create, insert, update and list the personal and academic details of students and the employee. Student need to design the database using ER- Model, create the database and Queries using SQL (DDL, DCL and DML commands)) and develop the Procedure & functions in the database. Finally, they need to demo the execution of database

List of Programs:

Exp. No.	Title	Week No.
1	Data Definition Language (DDL) commands in RDBMS	3,4
2	Data Manipulation Language (DML) and Data Control Language (DCL)	5,6,7
3	High level language extension with Triggers -	8
4	Procedures and Functions -	9
5	Database design using E-R model	10
6	Design and implementation of payroll processing system	11,12
7	Design and implementation of Student Information system	13,14