Adding and Deleting Relationships
• Adding new tables and relationships:
– Add the tables and relationships using CREATE TABLE statements with FOREIGN KEY constraints.
– If an existing table has a child relationship to the new table, add a FOREIGN KEY constraint using the
existing table.
• Deleting relationships and tables:
– Drop the foreign key constraints and then drop the tables.