What is a database?

  • A database is an organized collection of information (stored on a computer)
  • Information is organised into tables - each table contains records, fields and data.
  • Information stored in a table can be printed or displayed in a chart.
  • The information can be sorted into a particular order
  • The information can be searched for particular attributes e.g. in the customer table below you could search for all the people called "Mike" and print out their full name, address and telephone number. A search is normally called a query.


Here is an example of a database table

  • It contains 4 fields
  • It has 3 records
  • It has 12 items of data

Here is an example of a database record presented as a form (the database contains many such records)

  • It has 8 fields
  • It has 9 items of data

TASKS

1Write down the definitions of field, and record using your text book FIELD______

RECORD______

2Look at the database table below

a) How many records are there?______
b) How many fields are there?______
c) How many items of data are there?______
d) Write down an example of a field.______
e) Write down an example of a record.______
f) Write down an example of data.______
g) Write the name of a field that contains a number.______
h) Write the name of a field that contains date/time.______

Look at the database table below

a) How many records are there?______
b) How many fields are there?______
c) How many items of data are there?______
d) Write down an example of a field.______
e) Write down an example of a record.______

______
f) Write down an example of data.______
g)None of the fields are considered to be a number field - why are the telephone numbers NOT numbers?______

h) Why is Address split over 3 fields (hint - why would this be good if you were searching or sorting the data?)______

______

4Explain in your own words: field, record, data.

FIELD______

RECORD______

DATA______

5Sorts and Queries

Keywords:

  • ascending = 1, 2, 3 or a, b, c
  • descending = 3, 2 1 or c, b, a
  • > is greater than
  • < is less than

a)If the ArtistName field was sorted in ascending order whose name would appear first?

______

b)If the ArtistAge field was sorted in descending order whose name would appear first?

______

C)If a query was on ArtistAge with the criteria >50. Whose names would appear?

______

d) If a query was run on Nationality with the criteria NOT English or Welsh whose names would appear?

______

e) If a query was run on Artist Age with the criteria <40 and on Nationality with the criteria "English" whose names would appear?

______

f) Why do you think the ArtistName field has surnames followed by first names?b

- 1 -