Engineering Tutorials

CSE- 212 E Database Management Systems Lab

Class Work: 50
Exam: 50

I. Create a database and write the programs to carry out the following operation :

1. Add a record in the database

2. Delete a record in the database

3. Modify the record in the database

4. Generate queries

5. Generate the report

6. List all the records of database in ascending order.

II Develop two menu driven project for management of database system:

1. Library information system

(a) Engineering

(b) MCA

2. Inventory control system

(c) Computer Lab

(d) College Store

3. Student information system

(e) Academic

(f) Finance

4. Time table development system

(g) CSE, IT & MCA Departments

(h) Electrical & Mechanical Departments

Usage of S/w:

1. VB, ORACLE and/or DB2

2. VB, MSACCESS

3. ORACLE, D2K

4. VB, MS SQL SERVER 2000

Note: At least 5 to 10 more exercises to be given by the teacher concerned.

Related posts:

1. MDU Syllabus | F-Scheme | CSE- 212 F Database Management Systems Lab
2. CSE-202 E Database Management Systems
3. MDU Syllabus | F-Scheme | CSE-202 F Database Management Systems
4. CSE-434 E Advanced Database Management Systems
5. PTU Syllabus | CS– 305 DATABASE MANAGEMENT SYSTEMS