Page 87 - Viva ICSE Computer Studies 7 : E-book

7 Database and DBMS:

An Introduction

Learning Outcomes Let’s Learn About

• Introducti on to • Rules for Naming a Field
Students will be able to
Database • Data Types
• defi ne database and DBMS.
• Structure of Database • Setti ng Data Type for a
• list real-life examples of databases. • Microsoft Access Field
• design a database. • Components of • Primary Key
MS Access 2016 • Saving a Database
• describe diff erent data types.
• Starti ng Access 2016 • Closing a Database
• defi ne a primary key.
• Creati ng a New Database • Opening an Existi ng
• Views of a Table Database

Activity Corner

Identify whether the following falls under the category of data or database(organisation of the data).
1. Mathematics tables _________________
2. Brain where everything is stored _________________

3. CPU where everything is stored _________________

Introduction to Database

You must have observed at home how your parents organise important documents in a
fi le so that they can easily access them whenever required. Similarly, in places like offi ces,
schools and hospitals data is maintained so that it can be retrieved easily whenever needed.
A database helps you to organise the collected data in a tabular format. It allows you to enter,
access and analyse data. It also helps you to retrieve the required information easily. Hence,
a database is defi ned as an organised system to store and maintain data. For example, a list
of names of students and the marks obtained by them is organised in the form of a table in a
database. A database cannot be organised and maintained in Excel as a spreadsheet provides
limited features for databases. Therefore, we need a diff erent application software to manage
and maintain databases. The application software that creates and maintains a collection of
databases is called Database Management System (DBMS). DBMS manages all the functions of
a database. MS Access, one of the software of MS Offi ce, is an example of DBMS.

75