Credit Homework Database Questions

CHOOSE YOUR TEACHER FROM THE OPTIONS BELOW

Mr McGivern
Mrs Smith
Mr Carey
Mr Munro

A teacher uses a database package to keep track of her pupils' grades. The format of a record in the database is shown:

Given the maximum field size shown above, what would be the maximum number of bytes for one record? [PS] (1 point)

Resource 1

A floppy disc holds 1.44 megabytes. Use your answer to part (i) above to calculate how many records could be held on 1 floppy disc.
Show all working. [PS] (2 points)

Describe the steps the teacher should take to produce a list of all pupils in class 4H2 who have achieved an overall grade 1 or 2. [PS] (3 points)

Each pupil in the school has their photograph taken at the start of the year. How could a pupil's photograph be included in their record in the database? [PS] (2 points)

Resource 1

The teacher would like to print a list of pupils in order of merit. This list has to show all pupils of grade 1, followed by all pupils of grade 2, etc. Pupils with the same grade have to appear alphabetically by surname. A sample of what the teacher would like is shown.
What change would she need to make to the “Pupil” field so that she could produce the list shown above? [PS] (1 point)

Basic Operations

Advanced Topics & Practice

Helpful Extras

Homework

Credit Homework Questions

Database Homework 4

Name:
Email: (optional)