how many types of relationships can be creayed in base ? Explain each of them
Answers
Answer:
There are three types of relationships between the data you are likely to encounter at this stage in the design: one-to-one, one-to-many, and many-to-many. To be able to identify these relationships, you need to examine the data and have an understanding of what business rules apply to the data and tables.
hope it helps you
Explanation:
One to One: One entity is associated with another entity. For Ex: Each employee is associated with one department
- One to Many: One entity is associated with many other entities. For Ex: A company is associated with all working employees in one branch/office/country.
- Many to One: Many entities are associated with only one entity. For Ex: Many employees are associated with one project.
- Many to Many: Many entities are associated with many other entities. For Ex: In a company many employees are associated with multiple projects(completed/existing), and at the same time, projects are associated with multiple employees.