• Scenario
• Getting organised Planning
• Keeping track
• Gathering information
• Music database
• 
• Danceometer
• Invitation
• 
• Dancers only
• Make a catch
• 
• eportfolio
• Review

MUSIC DATABASE

You must create a database to store information about tracks that can be played during the Dance o'Clock Marathon. This will be used to create personalised play lists. Click on the Dancers only link to find out more.

The data you need has been provided in this text file. You can find out what the data items are by looking at this list. For example, the first one is the track ID.

Design and build a suitable database structure to store the data. Make sure that each field has a suitable name, data type, format and length. You must validate the two coded fields.

Ask a test user to check that your database structure is correct.

Import the data set. If records are rejected, check that your validation rules work as intended and keep a note of any rejected items for your eportfolio.

Create a data entry form so that new records can be added. Make sure that it is easy to use and helps to prevent the entry of invalid data.

Test your form by adding at least two new records to the database. These could be new releases or favourite tracks that are missing. Improve your form as necessary.

Save evidence of your database work for your eportfolio. Use the eportfolio checklist to make sure you save everything you need. Do NOT include the database itself.

Update your plan and project log.