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.

user-image
Question added by Imran Khan , Senior Officer , Sindh Education Founation
Date Posted: 2017/04/27
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

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.