Biology Forums - Study Force

Science-Related Homework Help Computer Studies Topic started by: anhsu on Feb 13, 2019

Title: Given the SQL statement: CREATE TABLE SALESREP (SalesRepNointNOT NULL,RepNamechar(35)NOT ...
Post by: anhsu on Feb 13, 2019

Given the SQL statement:

CREATE TABLE SALESREP (

SalesRepNo

int

NOT NULL,

RepName

char(35)

NOT NULL,

HireDate

date

NOT NULL,

CONSTRAINT

SalesRepPK

PRIMARY KEY (SalesRepNo),

CONSTRAINT

SalesRepAK1

UNIQUE (RepName)

);

We know that ________.

• RepName is the primary key

• RepName is a foreign key

• RepName is a candidate key

• RepName is a surrogate key

Title: Given the SQL statement: CREATE TABLE SALESREP (SalesRepNointNOT NULL,RepNamechar(35)NOT ...
Post by: amw87470 on Feb 13, 2019

Content hidden