Managing Data using DBMS Software

Collection of related data and data is a collection of facts and figures that can be processed to produce information.

DBMS follows the rules of normalization, which splits a relation when any of its attributes is having redundancy in values.

Consistency is a state where every relation in a database remains consistent.

DBMS follows the concepts of Atomicity, Consistency, Isolation, and Durability.

A user who is in the Sales department will have a different view of database than a person working in the Production department.

A user can apply as many and as different filtering options as required to retrieve a set of data.

Those who actually reap the benefits of having a DBMS. Can range from simple viewers who pay attention to the logs or market rates to sophisticated users such as business analysts.

Maintain the DBMS and are responsible for administrating the database.

A typical DBMS has users with different rights and permissions who use it for different purposes.

Group of people who actually work on the designing part of the database.