Part -2 : What is a Database?
A database is a collection of information that integrated logically different types of files and records together in a common place. It is organized in a manner that anyone can be accessed, managed and updated easily.
A database is divided into two parts :
1. Database Management System (DBMS).
2 Relational Database Management System (RDBMS).
1. DBMS : DBMS stands for database management system and it includes theoretical part that how data can be stored in table but it cannot combine or relates table with the other table.
The database management system is lacking in the part of Normalization. It does not include the process of Normalization. Only one person can access the database at the given time in DBMS.
In DBMS, you can arranged the data according to your requirement.
2. RDBMS : RDBMS stands for relational database management system that includes theoretical part as well as SQL syntax to relates tables with each other. It is object based database management system that maintain number of users at the same time.
The Normalization process is present in the relational database management system. This process is introduced by the Edgar Frank Codd.
Database Normalization is a process that can help to modify the existing database to bring its entire elements or tables to compile in a normal form.
The aim of database normalization is all the non key column in every table should be directly reliant on the key and this process will reduced the redundancies and will improve the efficiencies.
In RDBMS multiple user can access the database at the given time but you cannot arranged the data in any format, it allows only in rows and columns.
Posted on: January 21, 2010 If you enjoyed this post then why not add us on Google+? Add us to your Circles