IT- DATA BASE MANAGEMENT

               DATA BASE MANAGEMENT

 What is DATA BASE MANAGEMENT ?

• Database Management, allows a person to organize, store and retrieve data from a computer. Database Management can also describe, the data storage, operations and security 

 What is DBMS ?

• Full Form of DBMS-DATA BASE MANAGEMENT SYSTEM
• Data Base Management system is a data base programs
• Some of the examples of DBMS is MYSQL, Microsoft ACCESS, Oracle, RDBMS etc...... 

 

 What Is RDBMS ? 

A relational database management system (RDBMS) refers to a collection of programs and capabilities that is designed to enable the user to create, update, and administer a relational database, which is characterized by its structuring of data into logically independent tables. There are several features that distinguish a Relational DBMS from a DBMS, including:

• Structure: Where data is structured in hierarchical form in a DBMS, data is structured in tabular form in a RDBMS.
• User capacity: A RDBMS is capable of operating with multiple users. DBMS can only manage one user at a time.
• Software/hardware requirements: A RDBMS has greater software and hardware requirements.
• Programs managed: DBMS maintains databases within the computer network and system hard disks. A RDBMS manages the relationships between its incorporated tables of data.
• Data capacity: A DBMS is capable of managing small amounts of data and a RDBMS can manage an unlimited amount of data.
• Distributed databases: A DBMS does not provide support for distributed databases while a RDBMS does.
• ACID implementation: A RDBMS bases the structure of its data on the ACID (Atomicity, Consistency, Isolation, and Durability) model.

Difference between DBMS And RDBMS ?

DBMS represents a Database Management System. It is used to create/update/delete and maintain a database and it provides controlled access to data. RDBMS, Relational Database Management System, is an enhanced version of DBMS.

Following are the important differences between DBMS and RDBMS.

Sr. No.	Key	DBMS	RDBMS
1	Definition	DBMS stands for DataBase Management System.	RDBMS stands for Relational DataBase Management System.
2	Data Storage	Data is stored as file.	Data is stored as tables.
3	Data Access	In DBMS, each data elements are to be accessed individually.	In RDBMS, multiple data elements can be accessed at same time.
4	Relationship	There is no relationship between data in DBMS.	Data is present in multiple tables which can be related to each other.
5	Normalization	Normalization cannot be achieved.	Normalization can be achieved.
6	Distributed database	DBMS has no support for distributed databases.	RDBMS supports distributed databases.
7	Data Quantity	DBMS deals with small quantity of data.	RDBMS deals with large quantity of data.
8	Data Redundancy	Data Redundancy is common in DBMS.	Data Redundancy can be reduced using key and indexes in RDBMS.
9	User	DBMS supports single user at a time.	RDBMS supports multiple users at a time.
10	Security	DBMS provides low security during data manipulation.	RDBMS has multilayer security during data manipulation.
11	Example	MSAccess.	Oracle, SQL Server.