Design+and+build+a+database

Think of a topic you could store data about.

1. **On paper**, design the table. It should have at least 6 fields and at least 20 records. There should be at least one image field, and one numeric field Make sure that your design shows the data type of each field

Some examples might be:
 * Football teams (Name, nickname, stadium, year formed, country, badge)
 * Singers (Forename, surname, dob, biggest hit, number of albums, photo)
 * Films (Name, director, lead actor, lead actress, rating, poster)
 * etc.

2. Produce your database on a computer

3. Design a new layout for your table. You should consider different colours and include a graphic. The 2 most important fields should have a different font size to make them stand out

4. Your table should be sorted and a screenshot uploaded to your blog as evidence.

5. Decide on 3 questions that you want your database to help answer. Now use your database to search for the result.

Some examples might be:
 * Which teams were formed before 1890?
 * Which singer(s) have the first name John?
 * Which films did Quentin Tarrantino direct?

Capture all of your evidence (including photographs of paper work) and upload it to your blog