Question 27 of 32intermediate🔧 ApplyShort Answer1 mark

Add the constraint so that the price of an item is always greater than zero.

Correct Answer

ALTER TABLE UNIFORM ADD CHECK(Price > 0);

Exercise: EXERCISE | Q: 6(d) | (Page 49)
For More Understanding

Explanation

To ensure data integrity and restrict the Price column to accept only values greater than zero, a CHECK constraint is added to the table. The context demonstrates the use of the ALTER TABLE command with the ADD clause to modify existing tables (e.g., adding UNIQUE constraints or new attributes). Following this pattern, the query modifies the 'UNIFORM' table (inferred from the SCHOOLUNIFORM database context) to include the specified condition.

Solution Steps

  1. Step 1: Identify the table name (UNIFORM) and the column (Price) from the context.

  2. Step 2: Use the ALTER TABLE command with the ADD clause to add a new constraint.

  3. Step 3: Define the CHECK constraint with the condition 'Price > 0' to enforce the rule.

PreviousNext