Contacts table from Customers and Suppliers Tables

Question

original question, before submitting issue

"My Customers table contains Customers names (companies as well as persons)": I mean that my customers can be either physical persons or companies, so I think that we are in case of 1 customer can have 1 or many contacts, and 1 contact cannot belong to more than 1 customer.

So I made Contact Table containing ID, Name, .....  , CustomerID,SupplierID,EmpoyeeID, ... to show whitch category the contact is belonging to. I'm almost certain that this idea is not yet the best.

Then I created a new table: Companies with ID, CompanyName to indicates which Company is customer and supplier at the same time, in order no to have the same contact twice.

Please is there any better thoughts ?Thanks in advance .

Answer 1

"My Customers table contains Customers names (companies as well as persons)": I mean that my customers can be either physical persons or companies, so I think that we are in case of 1 customer can have 1 or many contacts, and 1 contact cannot belong to more than 1 customer.

So I made Contact Table containing ID, Name, .....  , CustomerID,SupplierID,EmpoyeeID, ... to show whitch category the contact is belonging to. I'm almost certain that this idea is not yet the best.

Then I created a new table: Companies with ID, CompanyName to indicates which Company is customer and supplier at the same time, in order no to have the same contact twice.

Please is there any better thoughts ?Thanks in advance .

Answer 2

Hi

Follow the steps:

1. Make a table of Supplier(attribute1,.......,attributen).

2. make an contactDetail table which contain (contact information )

3.Make a relation between one to many between Contact and Supplier.

Bye

---

Ahsan Kabir

Answer 3

Hi

Follow the steps:

1. Make a table of Supplier(attribute1,.......,attributen).

2. make an contactDetail table which contain (contact information )

3.Make a relation between one to many between Contact and Supplier.

Bye

---

Ahsan Kabir

Answer 4

@Ahsan, I have already passed that stage, Thank you any way.