A primary school is organising a range of 30 activities for its 550 pupils for the last day of term. The organiser wishes to create and use a database.
The following are essential.
Each pupil selects one activity. They must return a form which contains their name, class and emergency contact details.
The organiser provides class teachers with a list of pupils’ names and chosen activities.
Each activity has a leader and a unique activity name. Activity prices range from £2 to £30. The organiser provides a list for each activity leader, showing each pupil’s name, class and emergency contact details.
The organiser records which pupils have returned a form so that they can search for pupils who have not signed up to an activity
State two functional requirements of the database.
Was this exam question helpful?