Jump to content

purpose of using one to one,one to many/many to one and many to many


Recommended Posts

Basically to reduce duplication, and make it more manageable, instead of listing many branches under one company in a single record row, where you would end up with several columns for branches used for one company, then another company with very few branches would end up with remaining columns empty, wasting space and unnecessarily increasing database size.


By listing all brances in a many to one table and associating those branches with a one to many company id (containing singular info such as company website, email etc) you reduce having empty columns with less chance of duplicating branches associated with that company.

Edited by dsonesuk
  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...