SDD Topic has been refreshed!
You need to able to design your database before creating it.
We will look at 3 main areas
Entity Relationship Diagrams
We will now include strong/weak entities and relationship participation.
Data Dictionary
This is the same as at Higher except we will use MySQL data types.
Query Design
There are also SQL examples for these queries.