You must create a database for use at the club launch. The database will store information about youth organisations. Read the page Database demo to find out how it will be used.
The data you need has been provided by the National Youth Agency. This dataset is stored as a text file. You must create a database to store the data in an organised way so that it can be searched easily.
You can find out what the data items are by looking at this list. For example the first Item is a unique four digit code that identifies each organisation. Use the first two or three rows of the data to help you understand the list and work out what fields you need.
Design and build a suitable database structure to store the data. Make sure that each field has a suitable data type, format and length. You should include simple validation rules to ensure that only valid data is imported.
Ask a test user to check that your database structure works as intended. Once you are satisfied with your database structure, import the data set. If records are rejected, check that your validation rules work as intended.
Identify any rejected records.
Use this document to record the codes for these rejected records and try to explain why they are invalid. This file contains a complete list of codes in the original data set to help you.
Finally, check that all valid data has been imported correctly into your database.
pages 1 2