Data Dictionary Exam Machine

Stimulus: broken student activity data dictionary

A school activity sign-up system currently stores student registration data using inconsistent fields and unsuitable data types.

Current field	Description	Current type	Example	Issue

Complete the improved dictionary. Then answer the 3 MC, 2 short response and 1 extended judgement questions.

Field name	Description	Data type	Length	Example	Constraint

Which change best improves birth_date?

Keep INTEGER because dates have numbers Change to DATE because it stores a calendar date Change to BOOLEAN

Which field name is most consistent?

First Name email address student_id

Which extra field would best support analysis by local area?

postcode button_colour font_size

Justify two data type changes using the sample values.

Explain how validation or constraints improve data integrity.

Evaluate how your improved data dictionary supports reliable storage, filtering and future analysis.