Question

The relation with primary key can be created using

(a) Create table instructor (Id, Name)

(b) Create table instructor (Id, Name, primary key(name))

(c) Create table instructor (Id, Name, primary key (Id))

(d) Create table instructor ( Id unique, Name )

The question was posed to me in class test.

My question is based upon Reduction to Relational Schemas topic in section Database Systems Design and Implementation of Database Management

Answer 1

Correct answer is (c) Create table instructor (Id, Name, primary key (Id))

The explanation is: The value Name cannot be a primary key.