Centralised+Database+Systems

Typically an organisational information system will have a large and powerful [|database] at the centre.

A database is a computer program which is used to manage data. The data in a database is stored in one or more tables. Database tables can be related to each other.

A centralised database is a database which is run across a computer network, with the tables and files stored on one central computer.

The advantages of a centralised database system is that multiple users can all view, edit and update the same information. A centralised database makes it easy to back up data.


 * Exercise:**



1. Draw a diagram of a centralised database system. It should include the following:

5 workstations 1 computer running a centralised database system 1 computer for storing the database back-up

Underneath your diagram, list the advantages of a centralised database system

2. A vet practice has a database with two tables.

The first table is called CUSTOMER and it stores:
 * Customer name
 * Customer Address
 * Date of birth

The second table is called ANIMAL and it stores:
 * Animal name
 * Type of animal
 * Owner name

(a) Draw each table in your jotter. Complete each table by adding 4 records to each (these can be fictional) (b) The CUSTOMER and ANIMAL tables are related. In what way do you think they might be related?