Credit Homework Database Questions

CHOOSE YOUR TEACHER FROM THE OPTIONS BELOW (1 point)

Mr Munro
Mr McGivern
Mr Carey
Mrs Smith

A database is kept of all the racehorses in Britain. Details of the horses and their owners are stored. The format of the database is shown below:

How could the database be used to find all of the Chestnut horses standing over 15 hands high? (3 points)

Resource 1

What is the maximum number of bytes needed to store one record? (1 point)

How many records could be stored on a 1.44 Mb floppy disc. Show all of your working. (3 points)

The file has to be edited regularly throughout the day. State the type of access to the file that is required. (1 point)

A list of all owners with their surnames in alphabetical order is required. Why would it not be possible to generate this listing with the current database set-up? (1 point)

A new layout has been created as shown below.
How has the order of the list been created? (2 points)

Resource 1

Basic Operations

Advanced Topics & Practice

Helpful Extras

Homework

Credit Homework Questions

Database Homework 5

Name:
Email: (optional)