You would like to design basic customers and contacts application.
Prepare basic info. in spreadsheet format about customers and contacts like the following.
As you can see there is repeated data about customer name.
Customer Microsoft is repeated twice.
Customer Oracle is repeated three times.
You are managing Customers and Contacts.
You will make one table(table = spreadsheet ) for repeated data.
So there will be one table for Customers.
Data in the Customers table will be as following.
Structure of Customers table is as following.
Field/Column Customers_1_id will be maintained automatically by the system.
Please note that other features about Customers
e.g. Customer-Industry, Customer-Address etc. can be easily added at later time.
The rest which is left is Contacts.
Contacts-table will have link to Customers-table.
Data in the Contacts table will be as following.
Structure of Contacts table is as following.
Field/Column Contacts_1_id will be maintained automatically by the system.
Please note that there is link to Customers in structure of Contacts.
The link to customers will force to have a customer for each contact.
Please note that other features about Contacts
e.g. Contact-Phone-Numbers, Contact-Title etc. can be easily added at later time.
The latest document can be found at MyDataOrganizer_Design_Customers_Contacts_Application