Description
This SQL database booklet teaches pupils about:
- CREATE (database and table) and DROP (database and table) statements.
- Data types (varchar, integer, float, date, time)
- Constraints (PK, FK, not null, auto increment, checks [restricted choice and range check] )
- Data dictionary design
- Queries that use the HAVING clause
- Queries that use the NOT, BETWEEN, IN, ANY and EXISTS operators
- Sub-queries
The database supplied contains data about the Marvel Cinematic Universe movies from phase 1 to phase 3 (actors, movies and directors).
It was created for the Scottish Advanced Higher curriculum (year 12).
It would also be relevant to parts of the A-Level Computer Science course as well.
There are 30 tasks and the pack contains solutions to all tasks.
Highlights
Save even more with bundles
Description
This SQL database booklet teaches pupils about:
- CREATE (database and table) and DROP (database and table) statements.
- Data types (varchar, integer, float, date, time)
- Constraints (PK, FK, not null, auto increment, checks [restricted choice and range check] )
- Data dictionary design
- Queries that use the HAVING clause
- Queries that use the NOT, BETWEEN, IN, ANY and EXISTS operators
- Sub-queries
The database supplied contains data about the Marvel Cinematic Universe movies from phase 1 to phase 3 (actors, movies and directors).
It was created for the Scottish Advanced Higher curriculum (year 12).
It would also be relevant to parts of the A-Level Computer Science course as well.
There are 30 tasks and the pack contains solutions to all tasks.
