IGCSE ICT Database

IGCSE ICT Database: Organisation

by Miss Esha Abdullah

​You should be able to

Describe what is meant by the terms

​

• ​file​

• ​​record

• ​field

• ​key field

Multiple Choice

The software that we use to create a database is

• Microsoft Publisher

• Microsoft Excel

• Microsoft Word

• Microsoft Access

​Database

​An organised set of data is usually referred to as a database

​

​We will use some student data as an example

Multiple Choice

What is a database?

• Something that holds data

• something that finds data

• a program on a computer

• something that sends data

​What is a RECORD?

​The set of data associated with a single object or person is known as a record

​

​

​

​Here is Jess's Record

​Each student has their own record just like Jess's but with different data

Multiple Choice

In a database, all the information about one person or thing is called a 

• worksheet

• record

• presentation

• file

• ​Each student has their own record just like Jess's but with different data​​

• ​The data in each record is different, but each record has the same structure (each one has a name, d.o.b., phone, etc)​

• ​We say that each record contains the same field

​What is FIELD? and What is a FIELD NAME?

​You'll see that each of our student's records contain the same items. These items are known as fields.

​

​Each field has a field name (e.g. 'Date of Birth')

​

​Each field will contain different data in each of the record (e.g. in Jess's record, the phone field contains 7564356, but in Sita's record the Phone field contains 8565634 - same field, different data values

• ​The field is the box that you would write in

• ​The field name is the label next to the box

• The data is what you would write in the box

Multiple Choice

Which one is field Name?

• D.O.B

  The lable next to the box

• 3 Mar 1995

  What you would write in the box

• The box that you would write in

Multiple Choice

Which one is field?

• D.O.B

  The lable next to the box

• 3 Mar 1995

  What you would write in the box

• The box that you would write in

Multiple Choice

Which one is the data?

• D.O.B

  The lable next to the box

• 3 Mar 1995

  What you would write in the box

• The box that you would write in