CS2258 - DATA BASE MANAGEMENT SYSTEM LAB - Syllabus

CS 2258 DATA BASE MANAGEMENT SYSTEM LAB - Syllabus

(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).

(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.