Anna University Trichy 2009 B.Tech Information Technology Database Management System Lab - Question Paper

ANNA UNIVERSITY PRACTICAL EXAMINATION- OCT/NOV-2009
RAJARAJESWARI ENGINEERING COLLEGE (111)
Adayalampattu, Chennai-95.


Dept: info Technology. Date: 13.10.09 A.N.
Sub Code/Title: CS1307 /Database Management System Lab Duration: three hrs.
Year/Sem:III year/5th Sem


List of Experiments.


1. Write a Data Definition Language (DDL) Commands in RDBMS.

2. Write a Data Manipulation Language (DML) and Data Control Language Commands in RDBMS.

3. Write a High-level language extension with Cursors.

4. Write a High-level language extension with Triggers.

5. Write a PLSQL program for procedure and functions.

6. Database design using E-R model and Normalization.

7. Write program for embedded sql using Visual Basic.

8. Design and implementation of payroll processing system.

9. Design and implementation of Banking system.

10. Design and implementation of Library info system.






Internal Examiner External Examiner



1. Write a Data Definition Language (DDL) Commands in RDBMS.
2. Write a High-level language extension with Cursors
Aim
10 Algorithm
10 Program
50 Result
20 Viva
10




1. Write a Data Manipulation Language (DML) and Data Control Language Commands in RDBMS.
2. Write a High-level language extension with Triggers.
Aim
10 Algorithm
10 Program
50 Result
20 Viva
10




1. Write a PLSQL program for procedure and functions.
2. Write a Data Definition Language (DDL) Commands in RDBMS.

Aim
10 Algorithm
10 Program
50 Result
20 Viva
10




1. Database design using E-R model and Normalization.
2. Write a High-level language extension with Triggers.

Aim
10 Algorithm
10 Program
50 Result
20 Viva
10



1. Design and implementation of payroll processing system.

Aim
10 Algorithm
10 Program
50 Result
20 Viva
10





1. Design and implementation of banking system.

Aim
10 Algorithm
10 Program
50 Result
20 Viva
10




1. Design and implementation of Library info system.

Aim
10 Algorithm
10 Program
50 Result
20 Viva
10




1. Write a High-level language extension with Cursors.
2. Write a Data Manipulation Language (DML) Commands in RDBMS.
Aim
10 Algorithm
10 Program
50 Result
20 Viva
10

Earning:   Approval pending.