Int+2+Database+Systems+Assessment

In order to pass the Databases Systems unit at Intermediate 2, you must complete the following assessment tasks:

1. Research the topic for your database

2. On paper, design the table, clearly showing fields and their data types

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

4. Create the database as per the above design

5. Ask your teacher to give you 3 queries Provide printed evidence of each query
 * one simple search (single field)
 * one complex search (two fields)
 * one simple sort

6. Produce and print a report based on the above sort