Question 15 of 32beginner🔧 ApplyShort Answer1 mark

Using table level constraint, make TeamID as the primary key.

Correct Answer

ALTER TABLE TEAM ADD PRIMARY KEY (TeamID);

Exercise: EXERCISE | Q: 4(c) | (Page 48)
For More Understanding

Explanation

The question asks to make TeamID the primary key using a table level constraint. Based on the textbook context, the ALTER TABLE statement is used to add a primary key to an existing table. The syntax shown in the context is 'ALTER TABLE table_name ADD PRIMARY KEY (attribute_name);'. Applying this to the TEAM table with TeamID as the attribute gives the correct answer.

Solution Steps

  1. Step 1: Identify the table name as TEAM from the question context.

  2. Step 2: Use ALTER TABLE statement to modify the table structure.

  3. Step 3: Apply ADD PRIMARY KEY constraint on TeamID attribute.

PreviousNext