Page 23 - Code & Click - 8

The advantages of a DBMS are:

1. Controls Data Redundancy: Data redundancy refers to the duplication of data. In a DBMS, all
the data of an organisation is integrated into a single database file. Users access the centralised
database and do not maintain duplicate copies on their computers.
2. Facilitates Data Sharing : A DBMS stores data at a centralised location and facilitates sharing
of data among multiple users according to their requirements.

3. Controls Data Inconsistency : Data inconsistency exists when different versions of the same
data appear in different places. DBMS controls data inconsistency by updating the centralised
database.
4. Ensures Data Integrity : A DBMS supports database integrity. Data integrity means that the
data updated in the database follows standard rules and formats for all users.

5. Ensures Data Security : A DBMS ensures data security and privacy. It allows creation of user
accounts and granting them various access rights to prevent unauthorised access and modification
of data.
A Relational database is the most commonly used type of database model. It stores data in the form
of tables. A table organises data into rows called records and columns called fields. Each record in
a database contains data about one entity. Each field defines information of a certain type for all
records. Each table is given a unique name to identify it.

Let us view the structure of a table.
States of India

Name Capital Language Area (km )
2
Uttar Pradesh Lucknow Hindi 240,928

West Bengal Kolkata Bengali 88,752

The above table contains information about some states of India. It has four fields – Name, Capital,
Language, and Area, for the records – Uttar Pradesh, and West Bengal.

A DBMS based on the relational model is known as Relational Database Management System
(RDBMS). Some popular relational database management systems include Microsoft Access 2016,
IBM DB2, Oracle, MySQL, and Microsoft SQL Server.

MICROSOFT ACCESS 2016
Microsoft Access is one of the most popular RDBMS. It provides tools to create, edit, and update
databases quickly and easily.

Starting Access 2016 2
To start Access 2016 :
1. Click the Start button on the taskbar.
2. From the list of all programs, click Access.

Access 2016 starts and the Access Start Screen appears.

1

21