Inserting rows on tables that have foreign keys by using subqueries to look up actual values from other tables. An example for inserting on Employee with foreign keys to Super_SSN (Employee) and Dnumber (Department, along with an example for inserting on Dependent with a foreign key to SSN from Employee.