Table Querying   «Prev  Next»

Create a Table in SQL - Exercise

Create a Database Table

Objective: Given certain specifications, create a table that holds the information needed for a customer record.
Create the SQL statement necessary to create the new table, which will contain a customer's record, which consists of
  1. unique key,
  2. first name,
  3. last name,
  4. address, and
  5. phone number
. This was discussed in the last two lessons. The requirement for this exercise asks that you take into account expanded column requirements (last name and first name).
Submit your answer when you are done.