Using a one to many relationship in designing a database

Asked By carlesy 10 points N/A Posted on - 03/18/2012

When is the most appropriate instance for a database designer to make use of a one to many relationship?

• Status: Open
• Question Views: 737
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Access

Answered By Kanhai Else 0 points N/A #96629

Using a one to many relationship in designing a database

 

One to Many Relation ship occurs when between two domains of values, only one instance of the first domain can relate to many instances of the second domain but the reverse is not true.

Let me give an example where “many employees can work in single project while a single employee cannot handle multiple projects.” This is a many to one relationship.

As another example where, “a manager can handle many employees but an employee is under only one manager”

Another one “Many items are manufactured by a factory for a company but an item can be manufactured by only one factory.”

Another one “Many students can access a book at the library but only one can use it at a time.”

Another one “A part-time teacher teaches at many schools but a school can take only one part-time teacher for a subject”

 

Thanks

About Kanhai Else

Questions
0

Answers
56

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 03/18/2012
• Question Category: MS Access