What would be the relationship (either one-to-one, one-to-many or many-to-many) between: Customer and Sales Order and Sales Order and Inventory Inventory and Sales
What would be the relationship (either one-to-one, one-to-many or many-to-many) between:
Customer and Sales
Order and Sales
Order and Inventory
Inventory and Sales
Please explain this in detail so I can understand thanks!
One-to-one means direct relationship between two entities. Such a relation exists if each record of one table is related to only one record of the other table.
One-to-many means the relationship in which each entity may have with many other entities. Such a relation exists when each record of one table is related to one or more than one record of the other table.
Many-to-many means the relationship in which many entities of one set have with many other entities of another set. Such a relation exists when each record of the first table can be related to one or more from the second table, and each record from the second table can be related to one or more from the first table.
Step by step
Solved in 2 steps
