U2 Database Design Flashcards - Part A

Front

What is the significance of normalisation in database design?

Back

Normalisation helps to minimise data duplication and enables data integrity.

Front

What is the recommended first step before creating tables in a database?

Back

Design your tables in Word first.

Front

What is a composite key in database design?

Back

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

Front

When designing relationships, what type is most commonly used?

Back

One-to-many relationship.

Front

When would you use a one-to-one relationship?

Back

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

Front

What file format should you use to save your relationship screenshot?

Back

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

Front

What is a better way to ensure a presence check than just setting "Required" to "Yes"?

Back

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

Front

What is the purpose of a table lookup?

Back

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

Front

What settings should be changed in a lookup field to prevent invalid input?

Back

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

Front

When are value lookups suitable?

Back

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