DATABASE |
 |
|---|
You must create a database to store details of endangered species. Members will be able to download the database and use it to decide which animal to adopt.
The data you need has been provided in this text file. You can find out what the fields for the database are by looking at this list.
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.
Validate the Status and Threat fields.
Import the dataset. If records are rejected, check that your validation rules work as intended and keep a note of any rejected items for your eportfolio.
Save evidence of your database structure and validation rules in your EVIDENCE folder.
Create a data entry form so that more records can be added. It must:
include the logo and a sensible title
make sure it includes all the fields
include features to help the user enter valid data
include a key for coded fields
Ask for feedback from your test buddy and other test users. Make changes if necessary.
Save a screenshot of your data entry form in your EVIDENCE folder.
Find details of three more animals to add to the database. They must all be from one group.
Update your sources table.
Use your data entry form to add the new records to the database.
Save a screenshot of your new records in your EVIDENCE folder.
Save the database. You will use it to find information for your publications. However, you should not include it in your eportfolio.
Update your ongoing plan.
Print this page