SQL

• you do DELETE statement by using the structure of the SQL statement: DELETE FROM table_name WHERE condition
• normalisation is the process of organising data so that it is easy to retrieve and use
• to get to 1st normal form you must remove of repeating fields / attributes 
• to get to 2nd normal form you need to have all non-key attributes functionally dependent on the primary key
• 3rd normal form requires no transitive dependencies, meaning there are no partial dependencies between non-key attributes.
• the ER diagram shows relationships between entities and their attributes
• the different types of relationships are one to one, one to many, many to many
• a composite key is a key that is made up of multiple fields.
• a foreign key is a primary key from one table in another table that is used to relate the two tables