The database design quiz for the 12th-18th October covered implementation of a preferred address feature for customers. The first choice in the answers added a DEFAULT_ADDRESS_ID column to the customers table.
- If a quiz includes a choice with fields that reference a key from another table, is it necessary to define a FK for the choice to be correct? (If the question states that we must do something, for example to use valid addresses, I certainly agree that a FK would be necessary)
- In general, should questions include as many FKs and tables as possible? Or should FKs only be listed where directly impact the correctness of some of the choices?