For anyone wanting to get started setting up the physical environment in which their data will be stored, one of the first things they will need to do is to begin translating their logical model into a physical one.
Tables are where the data is logically grouped to facilitate reporting.
If there is to be a large amount of data in each table, then we would want to make sure that we are able to retrieve information as fast as possible, all the while optimizing our use of valuable database space. Text based information, like the names of customers, or addresses, will be best stored as varchar which is a variable character data type. This way, much needed database space can be conserved. If you have information that will typically be a fixed length, then you could use the char data type. Let's begin by taking a look at how to create a simple table.