Computer ScienceCode 2210
Databases
What this topic asks you to be able to do
- Define a database with a single table to meet the data storage requirements given
- Suggest which basic data types would be a good fit.
- Understand what a primary key is intended to achieve, and identify an appropriate primary key within a supplied database table.
- Read, understand and finish off structured query language (SQL) scripts which run queries on data held in a single database table