Question: what are the various types of relationships in database define them?
Answer: Database relationships are very similar in that they're associations between tables. There are three types of relationships: ... Each primary key value relates to only one (or no) record in the related table. They're like spouses—you may or may not be married, but if you are, both you and your spouse have only one spouse.