Definition: A relationship exists between two database tables when one table has a foreign key that references the primary key of another table.
Learn more about Database Relationships, Foreign Keys, JOINs and E-R Diagrams.
By Mike Chapple, About.com Guide