Create a database (CREATE DATABASE). Create a table definition (CREATE TABLE), including the creation of attributes with appropriate data types: CHARACTER, VARCHAR(r), BOOLEAN, INTEGER, REAL, DATE, TIME. Change a table definition (ALTER TABLE). Add a primary key to a table (PRIMARY KEY (field)). Add a foreign key to a table (FOREIGN KEY (field) REFERENCES Table (Field)). Queries including SELECT... FROM, WHERE, ORDER BY, GROUP BY, INNER JOIN, SUM, COUNT, AVG. Data maintenance including. INSERT INTO, DELETE FROM, UPDATE.

Show understanding of the normalisation process