Question

Which of the following is correct syntax for inserting foreign key constraint in a relation?

• A. ALTER TABLE table_name ADD FOREIGN KEY(attribute_name) REFERENCES referenced_table_name(attribute_name)
• B. ADD TABLE table_name ADD FOREIGN KEY(attribute_name) REFERENCES referenced_table_name(attribute_name)
• C. ALTER TABLE table_name REFERENCES referenced_table_name(attribute_name) ADD FOREIGN KEY(attribute_name)
• D. MODIFY TABLE table_name ADD FOREIGN KEY(attribute_name) REFERENCES referenced_table_name(attribute_name)

Answer 1

The Correct Option is A

The correct syntax for inserting a foreign key constraint in a relation is ALTER TABLE table_name ADD FOREIGN KEY(attribute name) REFERENCES referenced_table_name(attribute name).

Additional Context:

• Correct Syntax (Option 1):
  • Begins with ALTER TABLE to modify existing table
  • Uses ADD FOREIGN KEY clause
  • Specifies REFERENCES with target table and column
• Example Implementation:

  ALTER TABLE orders 
  ADD FOREIGN KEY (customer_id) 
  REFERENCES customers(customer_id);
      

• Why Other Options Fail:
  • Option 2: Incorrectly uses ADD TABLE
  • Option 3: Wrong clause order
  • Option 4: Invalid MODIFY TABLE command
• Key Requirements:
  • Referenced column must be a primary key or unique
  • Data types must match
  • Can add ON DELETE/UPDATE rules

Correct Answer: (1) ALTER TABLE table_name ADD FOREIGN KEY(attribute name) REFERENCES referenced_table_name(attribute name).