U2 Database Design Flashcards - Part A

Normalisation helps to minimise data duplication and enables data integrity.

Design your tables in Word first.

A composite key is composed of multiple fields and should be unique to meet the requirement of a Primary key.

One-to-many relationship.

When each record in Table A relates to only one record in Table B and vice versa.

PDF using ‘Microsoft Print to PDF’, named activity1.

Use "Validation Rule" = "Is not null" with a helpful "Validation Text" message.

To look up Foreign Keys and present values in a dropdown list.

Set "Limit to List" = Yes, "Allow value list edits" = No, "Allow multiple values" = No.

For short, fixed lists like days of the week or Gold, Silver, Bronze, etc.