DATABASE INTRODUCTION

Database: A database is an organized collection of related information in which facts are properly arranged and stored. 

A database is made up of a basic unit called “Table”. 

A table is made of different ‘Fields’ and ‘Records’. 

Record: Collection of organized data or related facts is called Record. 

Field: A field is a collection of same data types. 

DBMS (Database Management System): A database Management System is a tool for managing and manipulating information of a database. 

The main Functions of a DBMS is: 

1. Creating Database. 
2.  Adding Records. 
3. Modifying Records. 
4. Displaying Records. 
5.  Storing Records. 
6.  Deleting Records. 
7.  Generating Reports. 
8.  Printing Reports.

 Some Example of DBMS: MS Access, My-SQL,etc. 

Features of DBMS:

1. DBMS ensures data security.
2. DBMS facilitates the sharing of data among different database.
3. DBMS controls data inconsistency to a large extent.
4. DBMS reduces the data redundancy to a large context.

Data Consistency: Data consistency means that if any change is made in the data at one place, the corresponding changes in value of other information which is related to that data in other tables is also update.

Data Redundancy: Data redundancy mean storing of the same data in a duplicate form in different table separately in the same database.