what are relationships in database?
Database relationships. Database relationships are associations between tables that are created using join statements to retrieve data. ... Both tables can have only one record on each side of the relationship. Each primary key value relates to none or only one record in the related table.