Which of the Following Illustrates the Authors' Preferred Style of Defining

Multiple Choice

Which of the following illustrates the authors' preferred style of defining a primary key?

A) CREATE TABLE CUSTOMER (
CustomerID Integer Primary Key
LastName Char(35) Not Null
First Name Char(25) Null
B) CREATE TABLE CUSTOMER (
CustomerID Integer Not Null
LastName Char(35) Not Null
First Name Char(25) Null
CONSTRAINT CustomerPK PRIMARY KEY (CustomerID)
C) CREATE TABLE CUSTOMER (
CustomerID Integer Not Null
LastName Char(35) Not Null
First Name Char(25) Null
D) either B or C
E) The author does not demonstrate a preference for how to define a primary key.