Make Space

D201 Using ICT Summative Project Brief 2006.

 

CREATING A DATABASE

 

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.

 

you do not need to save this for your eportfolioDesign 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.handy hint

 

you do not need to save this for your eportfolioAsk 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.

 

you need to save this for your eportfolioIdentify any rejected records.handy hint

 

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.handy hint

 

you do not need to save this for your eportfolioFinally, check that all valid data has been imported correctly into your database.

 

mark alert checklist

pages 1 2