N4 Database Design and Development

A database is a program that is used to store organised information.

This is the modern equivalent of storing information on paper in filing cabinets.

• TRUE

• FALSE

A File is a collection of structured data on particular topic. A file is made up of:

• objects

• records

• tables

• Microsoft Access

What is a record? Select all that apply:

• information held about one person or one thing

• it is made up of fields

• has one data type

• always needs to be null

A field is a single item of information. An example would be:

• Dates of Birth for all pupils within classroom

• Date of Birth for only one pupil within classroom

Databases can be:

• Computerised

• Manual

• Fluid

• Transparent

Select all advantages of computerised databases:

• More than one person can access the information at one time.

• Searching for information is faster.

• Backup copies of information can be easily made and stored.

• Editing/updating information is easier and neater.

Select answer with correct types of fields:

• Text, Numeric, Date, Time, Object/Graphic, Calculated, Link

• String, Photo, Numeric, Time, Date, Link, Fixed

Computed or Calculated data type is a formula is used to do a calculation using one or more of the other fields.

• TRUE

• FALSE

When you create a record you must first consider:

• How many fields should there be.

• The data type for each field.

• What size each field should be.

• Data you put in the table.

Why would you use the search facility in your database file?

• To look where data change is needed

• To look for information in the database

• To delete redundant data within file

• To add new record