3. Database notation example

Following the rules from page two, see if you can write the correct database notation for the three tables below:

PK = primary key FK = foreign key

Employee table

Employee ID (PK)

Surname

Forename

Date of birth

Address line 1

Address line 2

Town

Postcode

Contact number

Department ID (FK)

Qualification ID (FK)

Date hired

Department table

Department ID (PK)

Department description

Qualifications table

Qualification ID (PK)

Qualification description

Check your answers on the next page

challenge see if you can find out one extra fact on this topic that we haven't already told you

Click on this link: Database Structures