Which of the following illustrates the author's preferred style of

defining a primary key?

$38)\_\_\_\_\_\_$

A$)$ CREATE TABLE CUSTOMER $($

CustomerID Integer Not Null

LastName Char$(35)$ Not Null

First Name Char$(25)$ Null

CONSTRAINT CustomerPK PRIMARY KEY $($CustomerID$)$

$)$;

B$)$ CREATE TABLE CUSTOMER $($

CustomerID Integer Not Null

LastName Char$(35)$ Not Null

First Name Char$(25)$ Null

$)$;

ALTER TABLE CUSTOMER

ADD CONSTRAINT CustomerPK PRIMARY KEY

$($CustomerID$)$;

C$)$ CREATE TABLE CUSTOMER $($

CustomerID Integer Primary Key

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.