• 4 hours
  • Easy

Free online content available in this course.



Got it!

Last updated on 2/3/21

Check Your Database Design Skills!

Evaluated skills

  • Identify the features of a well-designed database


Check What You've Learned About Structuring a Relational Database!

  • Question 1

    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.

  • Question 2

    Per the standards recommended in this course, which of the following are appropriate column names?

    Careful, there are several correct answers.
    • CustomerID

    • customerIdentification

    • Customer's Last Name

    • CustomerLastName

    • City

  • Question 3

    Which of the following are true of SQL script files?

    Careful, there are several correct answers.
    • 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.

Ever considered an OpenClassrooms diploma?
  • Up to 100% of your training program funded
  • Flexible start date
  • Career-focused projects
  • Individual mentoring
Find the training program and funding option that suits you best