Introduction
The requirement of modern days is to have an automated system that manages, modifies, and updates data accurately. This is achieved by a DBMS in robust, correct, and non-redundant way. DBMS lab aims at practicing and achieving this aim by using various software’s such as MYSQL, SQL PLUS. Database Management Systems (DBMS) are software systems used to store, retrieve, and run queries on data. A DBMS serves as an interface between an end-user and a database, allowing users to create, read, update, and delete data in the database.
Course Objectives
| COB-1 | To introduce basic concepts, architecture and characteristics of database systems. |
| COB-2 | To introduce relational model concepts and PL/SQL programming. |
| COB-3 | To introduce relational database design and Normal forms based on functional dependencies. |
| COB-4 | To introduce concepts of object oriented & distributed databases. |
Course Outcomes
| CO | Statement | Bloom’s Level |
| OCSE 407.1 | Ability to understand advantages of database systems.. | Remembering,
Understanding |
| OCSE407.2 | Ability to use SQL as DDL, DCL and DML. | Applying |
| OCSE407.3 | Ability to design database and manage transaction processing | Evaluating
Create |
| OCSE407.4 | Understand object oriented & distributed databases systems and use them. | Analysing |
CO-PO-PSO Mapping
| CO/PO | PO1 | PO2 | PO3 | PO4 | PO5 | PO6 | PO7 | PO8 | PO9 | PO10 | PO11 | PO12 | PSO1 | PSO2 |
| OCSE 407.1 | 2 | 3 | 2 | 2 | 2 | 2 | 2 | 1 | ||||||
| OCSE407.2 | 2 | 2 | 2 | 2 | 2 | 2 | ||||||||
| OCSE407.3 | 2 | 3 | 2 | 2 | 2 | 3 | 2 | 1 | ||||||
| OCSE407.4 | 2 | 2 | 2 | 2 | 2 | 1 |
Facilities
| Operating System /Software | ||
| Sr. No. | Name | Version |
| 1. | Windows | 10 pro |
| 2. | MYSQL | Open source |
| Hardware | |||
| Sr.No. | Equipment Name | Specification | Quantity |
| 1. | Computer | 13th Ge intel core i9,32 GB RAM | 24 |
| 2. | Printer | HP Laser jet, M1005MFP | 01 |
Staff
- Lab Incharge: Dr.S B Kumar
- Other Faculty Members: Rubeena Vohra
- Lab Assistent: Mr.Vishwajeet