Mis à jour le 03/02/2021
Check Your Database Design Skills!
- Identify the features of a well-designed database
Check What You've Learned About Structuring a Relational Database!
Which of the following is true of a primary key value?
The primary key is optional for any table.
Primary key values uniquely identify records in a table.
A primary key, once defined, always has the same value.
Primary keys are defined by their ability to speed up data retrieval.
Per the standards recommended in this course, which of the following are appropriate column names?Attention, plusieurs réponses sont possibles.
Customer's Last Name
Which of the following are true of SQL script files?Attention, plusieurs réponses sont possibles.
They're a great way to transport your database, specific objects, or data from one location to another.
They are not useful if you are updating a table on a customer’s machine.
Writing them requires specialized script-editing software.
They reduce the risk of human error due to manual updates.