Normalization two types of customers into one table

Posted by JDewzy on Stack Overflow See other posts from Stack Overflow or by JDewzy
Published on 2012-12-10T23:33:27Z Indexed on 2012/12/11 5:04 UTC
Read the original article Hit count: 76

Filed under:

I am trying to model a sales situation where you can sell to a person or to a business with a contact person. I cannot figure out the proper way to do this.

It seems like 2 tables would be incorrect. But how do I model a Customer table that can be a business or a person? Would I just have a boolean for "business" and an additional "business_name" field that would default to Null. But then I have to do an if/then on the columns and that seems like poor design.

Any advice, direction, or links is appreciated.

© Stack Overflow or respective owner

Related posts about database-design