Design+a+Database

For this task you will design a simple database to store information on a topic of your choice. Some examples might be:
 * Films
 * CDs
 * Artists / groups
 * Football team squad
 * Football teams
 * etc.

1. Research the topic for your database

2. On paper, design the table, clearly showing fields and their data types. Your database should have between 5 and 8 fields, and between 12 and 20 records. It should contain a container field for an image.

3. On paper, design of user interface/screen layout

4. Create the database as per the above design.

5. Come up with 3 queries which you could use for your database. Find the results of these queries.

6. Ask your teacher to give you 3 further queries Provide printed evidence of each query Produce and print a report based on the above sort
 * one simple search (single field)
 * one complex search (two fields)
 * one simple sort

7. Design an alternative layout