However, a product catalog is much more than that list of departments. In this chapter,
you??™ll add many new product catalog features, including displaying product lists and a product
details.
Review Figures 4-1, 4-2, and 4-3 to get a visual feeling of the new functionality you??™ll
implement in this chapter. More specifically, in this chapter, you will
??? Learn about relational data and the types of relationships that occur among data tables
and then create the new data structures in your database.
??? Learn how to join related data tables and even more theory about MySQL stored procedures
and techniques.
??? Complete the business tier to work with the new MySQL stored procedures, send
parameters, and pass requested data to the presentation tier.
??? Complete the presentation tier to show your visitor details about the catalog??™s categories,
products, and more.
Storing the New Data
Given the new functionality you are adding in this chapter, it??™s not surprising that you need to
add more data tables to the database. However, this isn??™t just about adding new data tables.
You also need to learn about relational data and the relationships that you can implement among
the data tables so that you can obtain more significant information from your database.
What Makes a Relational Database
It??™s no mystery that a database is something that stores data.
Pages:
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199