Page 18 - ModularV1.1 _c8_flipbook
P. 18
ADVANTAGES OF A DATABASE SYSTEM
A database system has many benefits. Some of the important advantages are:
It minimizes the duplication of data by integrating and sharing the data files.
It saves the storage space.
All the users are provided with some access rights or privileges and permissions.
The files can be easily updated whenever any changes are being made.
It improves the data integrity as data is stored in a central location.
It provides various techniques to recover and backup data.
It provides security to important and confidential data.
TYPES OF DATABASES
There are mainly two types of databases:
Flat File Database: It is a type of database that contains records having
small number of fields without any structured relationship between them.
The most popular example of flat file database is MS Excel 2010.
Relational Database: It is a type of database that stores data in several
Microsoft Office
tables and links those tables together to get a common piece of information.
Excel 2010
This type of database system is called Relational Database Management
System (RDBMS). Commonly used relational database systems are MS Access, Microsoft SQL
Server, ORACLE, etc.
Relational Databases
Clickipedia
The relational database was proposed by Edgar F. Codd. He gave a set of thirteen rules
(Codd’s rules) to define a Relational Database Management System.
STRUCTURE OF A DATABASE
Data is stored in the table of a database, as shown in the below diagram.
FIELDS
Reg No. Name Father’s Name Date of Birth Class
187/11 Krishna Kant Mr. K.S. Kant 15/08/2007 VIII
RECORDS 156/12 Rishi Sharma Mr. N.K. Sharma 22/10/2008 IX
IX
16/04/2008
Suraj Patel
194/11
Mr. G.S. Patel
123/12 Priyansh Sagar Mr. P.K. Sagar 18/06/2007 VIII
16 Modular (Ver. 1.1)-VIII

