CODEWITHSUNDEEP
mysqlsql-serverdatabasedatabase-designforeign-key-relationship
user3167881
user3167881

Reputation: 55

Separate Surname and Forename table

My boss want me to Split Person table into Surname and Forename table and then link to Person table with relationship.The purpose of it is basically eliminate data redundancy. Is it a Concrete suggestion?. Is it good to have separate table for forename and surname ???

Upvotes: 2

Views: 231

Answers (3)

Andy
Andy

Reputation: 2603

It depends :)

If the Person table is not really huge then it is really an overkill.

But if this table is going to grow humongously then perhaps it makes sense to partition it vertically by splitting it into 2 tables.

The arguments you can give to re-think on this new design is that it will take more time for select queries (as there will be joins involved), it will take more time to even save data because there will be multiple tables/indexes involved, and slightly more complicated to retrieve data due to joins etc.

Upvotes: 1

Martin Bean
Martin Bean

Reputation: 39389

Your boss is a muppet. Any “data redundancy” gains is quickly offset—and taken over—by a performance hit of having to join and query separate tables for a user’s name, increasing application complexity and in turn development time.

Upvotes: 2

Digital Chris
Digital Chris

Reputation: 6202

No. That is not good RDBMS. If each person has one and only one surname and forename (as is most always the case) then those fields should be added to the existing table and the "name" field removed.

Upvotes: 2

Related Questions