Activity database

You need to create an activity database which will detail the amount of energy used up by different activities. The text file containing all of the information for this database can be found here.

You need to design a suitable structure to store this data. You must make sure each field has a suitable name, length etc. You must also use validation rules where appropriate.

You need to ask a test user to check that your database structure is correct and then import the data set.

You should add 5 new activities to the database. These could be completely new activities or combinations of activities already in the database.

Save evidence of your database structure for your e-portfolio, including validation features. You will also need to include evidence of the 5 activities which you added. Do not include the whole database itself.

You will also need to calculate the calories burned per week for 5 test users and present this in a document.