141452 DBMS LAB IT SYLLABUS 4th Semester Anna University of Technology

141452                                                DBMS LAB                                              0  0  3  2

                   (Common to CSE & IT)

1. Data Definition, Table Creation, Constraints,

2. Insert, Select Commands, Update & Delete Commands.

3. Nested Queries & Join Queries

4. Views

5. High level programming language extensions (Control structures, Procedures and Functions).

6. Front end tools

7. Forms

8. Triggers

9. Menu Design

10. Reports.

11. Database Design and implementation (Mini Project).

LAB EQUIPMENTS

(Common to Information Technology & Computer Science Engineering)

Hardware and Software required for a batch of  30 students:

Hardware:

30 Personal Computers

Software:

Front end :  VB/VC ++/JAVA

Back end:   Oracle 11g, my SQL, DB2

Platform: Windows 2000 Professional/XP

Oracle server could be loaded  and can be connected from individual PCs.