Database Management System Lab

Introduction:

A Database Management System (DBMS) is a collection of programs that enables you to store, modify, and extract information from a database. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes. The following are examples of database applications:

  • Computerized library systems
  • Automated teller machines
  • Flight reservation systems
  • Computerized parts inventory systems

Objective:

The objectives that the management should keep in mind when they design and organize their data base management systems are:

(i) Provide for mass storage of relevant data,

(ii) Make access to the data easy for the user,

(iii) Provide prompt response to user requests for data,

(iv) The latest modifications to the database available immediately,

 

The DBMS Lab focuses on this very aspect and utilizes it in order to give the students a great experience at learning.

Equipments:

  • Hardware:
  • CPU: Pentium Dual Core E5400 @2.70GHz
  • RAM: DDR3 2 GB
  • OS: Windows 7 Ultimate (32 Bit)
  • HDD: 320 GB

 

  • Software:
    • Oracle 11g Release 2
    • SQL (Structure Query Language)

Industrial Prospect:

The DBMS is perhaps most useful for providing a centralized view of data that can be accessed by multiple users, from multiple locations, in a controlled manner. A DBMS can limit what data the end user sees, as well as how that end user can view the data, providing many views of a single database schema. With the computer hardware needed to support large data sets, DBMSs have more recently emerged as a fairly standard part of any company back office and our unique lab methodologies offer just that.