LAB MANUAL FOR DATABASE MANAGEMENT SYSTEM
CSE- 216 E L - T - Database Management Systems Lab P 2 Class Work: 25 Exam: 25 Total: 50 Duration of Exam: 3 Hrs. I. Create a database and write the programs to carry out the following operation : 1. 2. 3. 4. 5. 6. II Add a record in the database Delete a record in the database Modify the record in the database Generate queries Generate the report List all the records of database in ascending order. Develop a 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.
Rational behind DBMS Lab Database management has evolved from a specialized computer application to a central component of a modern computing environment and as a result knowledge about database system has become an essential part of computer science. The course serves as a visual guide to the material presented during our lectures. The aim of this course is to provide an introduction to Database management system, with an emphasis on foundational material The fundamental concepts and algorithms covered are based on those used in existing commercial or experimental database systems. Our aim is to present these concepts and algorithms in general setting. Objectives At the end of the course students should 1 have a good understanding of how several fundamental algorithms work, particularly those concerned with creation and updating of tables. 2 have a good understanding of the fundamental DBMS used in computer science 3 be able to understand various queries and their execution. 4 be able to design new database and modify existing ones for new applications and reason about the efficiency of the result
Software and Hardware Requirements Software Required: 1. VB, ORACLE and/or DB2 2. VB, MSACCESS 3. ORACLE, D2K 4. VB, MS SQL SERVER 2000 Hardware Required: Processor : Pentium III RAM : 128 MB Hard Disk : 40 GB