Explain why a given set of database tables are, or are not, in 3NF

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.