•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Database Design section within the Web Development category of DaniWeb, a massive community of 425,896 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 1,937 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Database Design advertiser: Programming Forums
Views: 401 | Replies: 0
![]() |
•
•
Join Date: Jul 2008
Location: Lahore, Pakistan
Posts: 1
Reputation:
Rep Power: 0
Solved Threads: 0
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
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
![]() |
•
•
•
•
•
•
•
•
DaniWeb Database Design Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
- Previous Thread: Help Understanding Constraints
- Next Thread: Database schema for a store


Linear Mode