Bayt.com

Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

When do we use "Many to One" Relationship in Database? Share some examples.

Database Microsoft Access
user-image
Question added by Imran Khan , Senior Officer , Sindh Education Foundation (SEF)
Date Posted: 2017/04/27
Upvote (0) Views (3) Followers (1) Answers (1) Report Question
Write an Answer
Register now or log in to answer.
MOHAMED MAHMOUD EISSA
by MOHAMED MAHMOUD EISSA , Software department MGR. and Senior developer , Global Media Services GMS

We use many to one all the time, because Many to one is a one to many relationship with different view point.

Examples:

[Department to Employees] is one to many and [Employees to  Department] is many to one  

[Customer to Orders] is one to many and [Orders to Customer] is many to one  

The common viewpoint to this kind of relationships is the one to many.

Hope this help

Write Your Answer
More Questions Like This