Relational Databases

normalization

Scenario

A bus company uses a relational database to help manage bookings.

You will investigate this database and answer some questions from the worksheet.

Click to access the simulator.

This unit will attempt to normalize the database, ensuring data integrity, data consistency and eliminating data redundancy.

You will be introduced the following concepts:

normal forms: 0NF, 1NF, 2NF, 3NF
4 types of key: primary, foreign, composite, concatenated
Entity Relationship Diagrams
Crows' Feet
Data Integrity and Data Redundancy
Schema : Conceptual, Logical, Physical,

Units

essential vocabulary

database import evidence table integer screenshot record text field double data type