Primary key & Composite key

11.4.1.3 explain the difference between primary composite and foreign key

Normalisation database

1. Definition
2. 1NF
3. 2NF
4. 3NF
5. Questions
6. Exercises
7. Exam questions

11.4.1.5 define the connections between tables in database(1-3NF)

Entity Relationship Diagrams

1. Definition
2. Types of relationship
3. Questions
4. Exercises
5. Exam questions

11.4.1.6 define the connections between tables in database

11.4.1.7 create an entity-relationship (ER) model

How to create database and table in phpMyAdmin?

Data types of MySQL database

1. Data types
2. Example
3. Questions
4. Exercises
5. Exam questions

11.4.1.4 define data types when creating a database

Database MySQL in phpMyAdmin

Relational databases 
11.4.1.1 describe relational databases and their purpose
11.4.1.2 use the terms "table", "attribute", "record", and "index" to describe databases
11.4.1.3 explain the difference between primary, foreign and composite keys

1. What is a relational database?
2. Table, attribute and record
3. What is an index?
4. Key laboratory
5. Exercises
6. Exam-style practice