Design

You need to able to design your database before creating it.

We will look at 3 main areas

1. Entity Relationship Diagrams

We will now include strong/weak entities and relationship participation.

1. Data Dictionary

This is the same as at Higher except we will use MySQL data types.

1. Query Design

There are also SQL examples for these queries.