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 _____.
A. None of these statements are true
B. RepName is the primary key
C. RepName is an alternate candidate key
D. RepName is a surrogate key
E. RepName is a foreign key
