Slides badge

Analysis

Learning Intentions

  • Identify and explain different requirements of database solutions
  • Identify the end-user and functional requirements of a database problem

Success Criteria

  • I can identify and describe requirements of a database solution
  • I can identify end-user and functional requirements of a database problem

End-user requirements

  • An end-user is the person or people or business that is going to be using the database.
  • End-user requirements are included in a planning document that details what the client wants to be able to do with a database solution.
  • These requirements should also include details of queries that will need to be generated that the client would like to be able to perform.
Customer base icons created by xnimrodx - Flaticon

Example

Staff who are managing the school library must be able to display information about borrowed books by carrying out different types of searches. These searches should include the following details:

  • pupil details
  • book title
  • book author
  • due date

The results of these searches should include:

  • pupil name
  • pupil class
  • pupil telephone number
  • book title
  • book author
  • book genre
  • date borrowed
  • due date

Library staff should also be able to enter data into the system and search for overdue books. The head teacher should be able to sort results of searches in descending order of number of books borrowed to identify the most active readers and the most popular books in the school.

Functional requirements

  • Functional requirements describe what the database system should do. 
  • They should include:
    • Operations to be carried out by the user on the database
    • Types of data to be entered and stored
    • What should happen to the data (e.g. calculated or processed)
    • The way in which the user interacts with the database
Database icons created by Elzicon - Flaticon

Example

Fields to store the following information will be required:
  • borrower forename
  • borrower surname
  • borrower address
  • borrower telephone
  • borrower email
  • book.isbn
  • book title
  • book author
  • book genre
  • book shelf location
  • book borrower email
Borrower
Borrower forename
Borrower surname
Borrower address
Borrower telephone
Borrower email
Book
Book ISBN
Book Title
Book Author
Book Genre
Book Shelf Location
Book Borrower Email

Example

Fields to store the following information will be required:
  • borrower forename
  • borrower surname
  • borrower address
  • borrower telephone
  • borrower email
  • book.isbn
  • book title
  • book author
  • book genre
  • book shelf location
  • book borrower email
Borrower
Borrower forename
Borrower surname
Borrower address
Borrower telephone
Borrower email
Book
Book ISBN
Book Title
Book Author
Book Genre
Book Shelf Location
Book Borrower Email

Past Paper Questions

A youth club plans to create a database to store details of club members.

 

The youth club leaders have been discussing the requirements of the
new database.

 

Use the information above to identify two functional requirements.

 

2 marks

Text

Past Paper Questions

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.

 

2 marks

Presentation Overview
Close
JB
Analysis
© 2020 - 2026 J Balfour
23:53 | 22-04-2026
Join Live Session
Go Live
Start Remote
Save Progress
Slideshow Outline
Presenter Mode
Bullet Only Mode
Generate Quiz
Generate Lesson Plan
Widget Screen
Canvas Controls
Fullscreen
Random Selector
Timer
Volume Meter
Binary Converter
Python Editor
Show Knox 90
Provide Feedback
Help
!
Keywords
    DragonDocs Management
    Random selector
    Set a timer for how long?
    10:00
    5:00
    3:00
    2:30
    2:00
    1:00
    ...
    Sections
      Binary conversion
      Denary to binary conversion
      Binary to denary conversion
      Feedback 👍
      Accessibility

      Apply a filter:

      Apply theme

      Blue theme
      White theme

      More effects:

      Dark Mode
      Bold Text
      Slide Zoom
      ×
      Loading
      All slideshow files