removed foreign key constraints from db
in more realistic app, would have links to related fields, perhaps selecting with a drop down. In any case the database was set up so entering a customer id, for example, on an order field would need to refer to a real employee.