hi all, i have a scenario to discuss with you all expert people....
i want to save
contact(phone , fax, email, mobile, contact pesonName, contactPersonPhone)
this information will be saved for more than one entities like....
a client will have a contact
a company will also have a contact
as i am working on a Real estate Enterprise solution so there is also an entity like building that also has some contact
so in this scenario we got three entities that can have contact
so how can we best manage this thing is database...
i came up with a solution that is
create three entities (client, company, and building) and one entity contact
also three tables client, company and building one for each entity and a contact table
and i put a foreign key of contact in each table of client, company and building
is this a better solution
or
should i make separate table to save contact for each entity