Top Posters
Since Sunday
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
r
4
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
trea48 trea48
wrote...
Go to Answer
Posts: 450
Rep: 0 0
5 years ago
Which of the following illustrates the authors' preferred style of defining a primary key?

• CREATE TABLE CUSTOMER (
CustomerIDIntegerPrimary Key
LastNameChar(35)Not Null
First NameChar(25)Null
);

• CREATE TABLE CUSTOMER (
CustomerIDIntegerNot Null
LastNameChar(35)Not Null
First NameChar(25)Null
CONSTRAINT CustomerPK PRIMARY KEY (CustomerID)
);

• CREATE TABLE CUSTOMER (
CustomerIDIntegerNot Null
LastNameChar(35)Not Null
First NameChar(25)Null
);
ALTER TABLE CUSTOMER
ADD CONSTRAINT CustomerPK PRIMARY KEY (CustomerID);

• Both CREATE TABLE CUSTOMER (
CustomerIDIntegerNot Null
LastNameChar(35)Not Null
First NameChar(25)Null
CONSTRAINT CustomerPK PRIMARY KEY (CustomerID)
);

and

CREATE TABLE CUSTOMER (
CustomerIDIntegerNot Null
LastNameChar(35)Not Null
First NameChar(25)Null
);
ALTER TABLE CUSTOMER
ADD CONSTRAINT CustomerPK PRIMARY KEY (CustomerID);

are correct
Textbook 
Database Processing: Fundamentals, Design, and Implementation

Database Processing: Fundamentals, Design, and Implementation


Edition: 15th
Authors:
Read 56 times
2 Replies
Replies
Answer verified by a subject expert
Va97001Va97001
wrote...
#1
Posts: 395
Rep: 50 0
5 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here
1

Related Topics

trea48 Author
wrote...
#2
5 years ago
Brilliant
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1015 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 287
  
 450
  
 13473
Your Opinion
What's your favorite coffee beverage?
Votes: 274
Previous poll results: Who will win the 2024 president election?