U2 Database Design Quizs - Part A

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

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

• When each record in Table A can relate to multiple records in Table B.

• When records in Table A are not related to any records in Table B.

• When each record in Table A relates to at least one record in Table B.

What is the significance of normalisation in database design?

• Normalisation helps to minimise data duplication and enables data integrity.

• Normalisation increases data redundancy and complexity.

• Normalisation is used to enhance the speed of database queries.

• Normalisation eliminates the need for data relationships.

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

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

• Set the field to "Visible" only when filled.

• Implement a default value for the field.

• Use a custom script to check for input.

How do you provide the user with a prompt to enter data in a query?

• Use curly braces in the Criteria row, e.g. {Enter the start date:}

• Use square brackets in the Criteria row, e.g. [Enter the start date:]

• Use parentheses in the Criteria row, e.g. (Enter the start date:)

• Use angle brackets in the Criteria row, e.g.

How does limiting lookups to the list help data integrity?

• Ensures only predefined, valid values can be selected, preventing errors.

• Allows any value to be entered, increasing flexibility.

• Reduces the need for data validation checks.

• Increases the complexity of data entry processes.

When are value lookups suitable?

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

• For long, variable lists that change frequently.

• For complex data structures requiring extensive processing.

• For large datasets that need to be sorted and filtered.

How can you determine due date status in a query if you need to consider whether it is "Due Today" or "Not Yet Due"?

• =IIf([Due Date]

• =IF([Due Date]>Date(),"Not Yet Due",IF([Due Date]=Date(),"Due Today","OVERDUE"))

• =IIf([Due Date]>Date(),"OVERDUE",IIf([Due Date]=Date(),"Not Yet Due","Due Today"))

• =IF([Due Date]=Date(),"Not Yet Due",IF([Due Date]

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

• Design your tables in Word first.

• Create a database schema directly in SQL.

• Start entering data into the tables immediately.

• Consult with a database administrator.

What do the following input mask symbols mean: L, 0, >L?

• L: required letter, 0: required digit 0-9, >L: required uppercase letter.

• L: optional letter, 0: optional digit 0-9, >L: optional uppercase letter.

• L: required letter, 0: required digit 1-9, >L: required lowercase letter.

• L: required letter, 0: required digit 0-9, >L: required lowercase letter.

What is an example of a formula using a mathematical operation in a query.

• =10*[Monthly Rent]*[RentDurationInYears]

• =12*[Monthly Rent]*[RentDurationInYears]

• =15+[Monthly Rent]*[RentDurationInYears]

• =12*[Monthly Rent]+[RentDurationInYears]