Marathon Man

Problem Description:

You are going to design and partially implement a database to store information about marathons and runners.

The Marathon Man worksheet will take you through the steps of analysing and designing parts of the database, implementing a table (including linking tables together), inputting data and searching the database

Your teacher will provide you with the Marathon Man Worksheet via Google Classroom. They will also show you where to find the Marathon Man Starter Database

To achieve level 4 you need to:

• Identify suitable data types for fields

• Create a database table

• Create a primary key

• Establish a relationship between tables

• Include a QR code field

• Create a form for data entry

• Create a simple search

• Create a complex search

Show your understanding of National 5 elements by:

• Creating a partial data dictionary

• Identifying a foreign key field

• Create a relationship that uses referential integrity

• Create a lookup for data entry

• Input data using a SQL query

• Create a search query with SQL

Your worksheet, program and testing evidence should be submitted electronically via Google Classroom.