Rob creates a course_details table that has four columns: course_id, course_name, semester and credits. a course may have 0.5 credit if it is for 1 semester and 1 credit if it is for 2 semesters. which field should rob assign as a primary key in the table? rob should assign the field as the primary key in this table.

Course_ID should be the primary key

Explanation:

In databases, the primary key of a table must be a field that identifies uniquely every record possible in that table. Most common way is to assign a number starting from 1 and incrementing every new record is added to the table.

Since primary keys cannot be duplicated, the fields Course_Name, Semester and Credits, are not good choices.

The syntax for adding a primary key is:

ALTER TABLE Course_Details ADD PRIMARY KEY (Course_ID);

the answer is c