Member Avatar for moomal.razak

Why cannot we merge one to one relationship entities in one column?

  • 2 Contributors
  • 1 Reply
  • 89 Views
  • 40 Minutes Discussion Span
  • Latest Post Latest Post by code739
Member Avatar for code739

ok lets think of a db design that has a one two one relation ship

maybe table_1 has column firstname and table_2 could have column gender is not consider as one to one relationship becuase in a table gender one gender could have assign to any person.

So lets start with the example of table_1 has a column of firstname
table_2 has a column student id this is an example of one to one relationship because not all student has a the same school id, however this design seems so pointless becuase you could join this column to table_1 instead of separating it the different table..

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.