Introduction to DBMS

Unit 1: Relational Databases

Part I: Introduction to DBMS

Syllabus

Purpose of Database System - Views of data - Data Models - Database System Architecture - Introduction to relational databases - Relational Model - Keys Relational Algebra - SQL fundamentals - Advanced SQL features - Embedded SQL- Dynamic SQL.

Introduction

• Definition: A Database Management System (DBMS) is a collection of interrelated data and various programs that are used to handle that data.

• The primary goal of DBMS is to provide a way to store and retrieve the required information from the database in convenient and efficient manner.

• For managing the data in the database two important tasks are conducted -

  (i) Define the structure for storage of information.

  (ii) Provide mechanism for manipulation of information.

• In addition, the database systems must ensure the safety of information stored.

Database System Applications

There are wide range of applications that make use of database systems. Some of the applications are -

1) Accounting: Database systems are used in maintaining information employees, salaries, and payroll taxes.

2) Manufacturing: For management of supply chain and tracking production of items in factories database systems are maintained.

3) For maintaining customer, product and purchase information the databases are used.

4) Banking: In banking sector, for customer information, accounts and loan and for performing banking applications the DBMS is used.

5) For purchase on credit cards and generation of m`onthly statements database systems are useful.

6) Universities: The database systems are used in universities for maintaining student information, course registration, and accounting.

7) Reservation systems: In airline/railway reservation systems, the database is used to at maintain the reservation and schedule information.

8) Telecommunication: In telecommunications for keeping records of the calls made, generating monthly bills, maintaining balances on prepaid calling cards, and storing information about communication networks the database systems are used.