Aloha,
I'm new to database design and have a basic question. I'm writing a customer database. All of the customers can have several contacts. I've created a Customer table, and also a Contacts table. The contacts table stores name, email, phone number, title, etc. However, all of the customers can also have contacts within our company (account rep, sales engineer, project manager, etc.). These contacts have the same information as the customer contacts. The only difference is that these company contacts can be the same for multiple customers (many to many relationship). Should I create a separate table for these contacts (e.g. CompanyContacts), or should I just use one table for all contacts and have a field to indicate whether or not they are a company contact?
Thanks in advance,
Frank