Until then, you??™ll
manually fill in the database with data (or you can ???cheat??? by using the SQL scripts provided in the Source
Code/Download section of the Apress web site at http://www.apress.com, as you??™ll see).
Another particularly important detail that you need to think about is whether a category
can exist in more than one department and whether a product can exist in more than one category.
As you might suspect, this is the kind of decision that has implications on the way you
code the product catalog, so you need to consult your client on this matter.
For the TShirtShop product catalog, each category can exist in only one department, but
a product can exist in more than one category. For example, in our catalog, the product Kat Over
New Moon will appear in both Animal and Christmas categories. This decision will have implications
in the way you??™ll design the database, and we??™ll highlight those implications when we get there.
Finally, apart from having the products grouped in categories, you also want to have featured
products. For this web site, a product can be featured either on the front page or in the
department pages. The next section shows a few screenshots that explain this.
Previewing the Product Catalog
Although you??™ll have the fully functional product catalog finished by the end of Chapter 5, taking
a look at it right now will give you a better idea about where you??™re heading.
Pages:
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135