CREATE TABLE person
(person_ id SMALLINT UNSIGNED,
fname VARCHAR(20),
lname VARCHAR(20),
CONSTRAINT pk_person PRIMARY KEY (person_id));
a. Normal attribute of the table |
b. Super key |
c. Composite key |
d. Primary key |
Answer: Super key |
CREATE TABLE person
(person_ id SMALLINT UNSIGNED,
fname VARCHAR(20),
lname VARCHAR(20),
CONSTRAINT pk_person PRIMARY KEY (person_id));
a. Normal attribute of the table |
b. Super key |
c. Composite key |
d. Primary key |
Answer: Super key |