A database table is a two-dimensional array of columns and rows. Tables normally describe places (such as stores), people (such as customers), objects (such as inventory), or relationships (such as sales transactions).

Let’s say that you wish to create a customer table. You might consider the following attributes:

                    Customer ID
                    Customer First Name
                    Customer Last Name
                    Customer Street Address
                    Customer City
                    Customer State
                    Customer Zip Code
                    Customer Phone Number
                    Customer Credit Limit

You can build an SQL command to create this table. For each column, you specify its name, its data type, and possibly one or more constraints as follows:

          CREATE TABLE CUSTOMER_TABLE (
                        CUST_ID                INTEGER        NOT NULL,
                        FIRST_NAME         CHAR(20),
                        LAST_NAME           CHAR(30)      NOT NULL,
                        STREET_ADDRESS CHAR(30),
                        CITY                       CHAR(20),
                        STATE                    CHAR(2),
                        ZIP_CODE              INTEGER,
                        PHONE_NUMBER    CHAR(14),
                        CREDIT_LIMIT        DECIMAL(11,2)
                        );

Now let’s consider creating a sales transaction table. If you have questions about the sale, you would like to have a phone number. If you put the phone number on the sales transaction, you will be repeating the same phone number on each sales ticket for each item processed, but the customer is buying your product and the phone number would occur only once if it is in the customer table. If you wish to change the phone number, you have only one place to change it if it is in the customer table. Look for the most logical association for locations of data.