Activities

Complete a data dictionary for each of the following database tables. Go back to the previous page and look at the examples for all required headings of a data dictionary.

Remember to include data types and character lengths, and keep size for display reasonable (e.g. top 250 movies will not need any more than 3).

  1. Table: IMDB Top 250 Movie Rankings

Movie_ID
Movie_Name
Movie_Score

1

The Shawshank Redemption

9.3

2

The Godfather

9.2

3

The Dark Knight

9.0

  1. Table: Year 10 200 Hour Electives

Student_ID
First_Name
Surname
Course_Name
Class_Code

1337

Shah Rukh

Khan

Drama

10DRA2

1338

Grace

Hopper

Computing Technology

10CT2

1339

Edith

Clarke

Industrial Technology Engineering

10ITE12

1400

Nikola

Tesla

Industrial Technology Engineering

10ITE22

Last updated