Database

DATABASE

Database is a collection of related data and data is a collection of facts and figures t
processed to produce information.


DATABASE MANAGEMENT SYSTEM (DBMS)

A database management system stores data in such a way that it becomes easier t
manipulate, and produce information.

, CHARACTERISTICS OF DBMS
Traditionally, data was organized in file formats. DBMS was a new concept then, a
research was done to make it overcome the deficiencies in traditional style
management. A modern DBMS has the following characteristics


• Real-world entity − A modern DBMS is more realistic and uses real-world entitie
its architecture. It uses the behavior and attributes too. For example, a university
may use students as an entity and their id as an attribute.


• Relation-based tables − DBMS allows entities and relations among them to form
user can understand the architecture of a database just by looking at the table nam


• Less redundancy − DBMS follows the rules of normalization, which splits a rela
any of its attributes is having redundancy in values. Normalization is a mathema
and scientific process that reduces data redundancy.