I was given this info in another question (listed below *) I had but I am not sure how to even name tables or columns properly or what data type is what.

Can you provide me with examples of some small business items I would use to name the table, columns, etc and what data type they are? Can I get better explanation on number 5 through 10. Also how many tables then do I need? one for customer, one for supplier, one for employees? Im so confused. Thank you.

Answer I was provided during another question....

*In the first step we have to create table and then Entity relationship diagram and after that SQL script Now there are further steps that how we can create table,Entity relationship diagram and SQL script that all are in explanation form.

Steps to create TABLE

1)First go to the file option and then select New Model 2)Then Select the first option that is Add Table and Double Click on the Add Table Option 3)Give a name for the table that you want to create 4) Type name of the column under the column name option 5) From the drop-down list select the appropriate data type under the datatype 6) for constraints such as PK that is for primary key and NN that is for not null Check that given checkbox 7) Select foreign keys tab at the bottom horizontal bar if the table has a foreign key 8) For the foreign key column type the name 9) The table where this foreign key is the primary key than select the table from the drop-down list 10) Under Column As all the column automatically appear on the right-hand side than select an appropriate column from referenced column drop-down list 11) To create each table follow the above step