Data Dictionary Exercises

Exercise 1 – College

Create a Data Dictionary for the following entities and attributes:

STUDENT SUBJECT

Student ID No Subject

First Name Day

Surname Time

Student ID No*

Use the following format: Draw a table out with the headings as shown.

Entity / Attribute / Type / Validation

For the Type and Validation – look at the notes we have just covered. Look at the sample data (in the normalisation exercises to help you).

Remember the attributes underlined are the primary keys, the asterisk * denotes the foreign key.

Exercise 2 – Ships and Ports

Create a Data Dictionary for the following entities and attributes:

SHIP PORT

Ship ID Port ID

Ship Name Registered Port

Cargo Bay Capacity Mooring Fees

Daily Cost Ship ID*

Exercise 3 – Scot Gas

Create a Data Dictionary for the following entities and attributes:

INSPECTOR VISIT

Inspector No Inspection Date

Inspector Name Inspection Time

Inspector Mobile No Customer No

Inspection Area Inspection Type

Inspector Qualification

Customer No*

Exercise 4 – Sports

Create a Data Dictionary for the following entities and attributes:

INSTRUCTOR CLASS

Instructor ID Class Code

Instructor Name Sport Class

Class Code* Level

Cost Per Class

Exercise 5 – Holiday Booking

Create a Data Dictionary for the following entities and attributes:

CUSTOMER HOTEL

Customer No Hotel Code

Name Hotel Address

Address No of Rooms

Hotel Code* Duration of Stay

Exercise 6 – Cinema

Create a Data Dictionary for the following entities and attributes:

FILM ACTOR

Title No Actor No

Description Actor Name

Censor Rating Role Played

Film Class

Actor No*

Exercise 7 – Timetables

Create a Data Dictionary for the following entities and attributes:

LECTURER COURSE

Lecturer No Course Code

Name Start Date

Faculty Weekly Time

Office Location

Course Code*

Exercise 8 – Courses

Create a Data Dictionary for the following entities and attributes:

SOLDIER COURSE

Soldier ID Course Code

Name Course Title

Course Code* Session No

Course Date

Grade