June 2005
Intermediate
720 pages
20h 6m
English
The e-commerce site in this example will use the simply named ecommerce database. It was marginally used in Chapter 11, but without the structure it will have here. I’ll explain each table’s role prior to creating the database in MySQL.
With any type of e-commerce application there are three broad kinds of data to be stored: the product information (what is being sold), the customer information (who is making purchases), and the order information (what was purchased and by whom). Going through the normalization process (see Chapter 5, “Advanced SQL and MySQL”), I’ve come up with five tables (Figure 14.1).
Read now
Unlock full access