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 authors do not demonstrate a preference for how to define a primary key.

Question

Quizplus · Accepted Answer

The authors' preferred style of defining a primary key is to use the CONSTRAINT keyword to explicitly define the primary key and give it a unique name (in this case, "CustomerPK"). This provides more clarity and organization within the table definition, as well as making it easier to reference the primary key in other parts of the database schema. Additionally, it ensures that the primary key is explicitly defined as NOT NULL, which is important for maintaining data integrity.

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