|
|
Welcome to the first case study of this book! Here you'll analyze the scenario of a simple product catalog, a common requirement for many software products and Web sites today.
The chapter starts by discussing how to create the data tables, their properties (data types, relationships, constraints, and so on), and the relationships between them. Then, after adding some sample data to the database, the chapter discusses how you can perform different kinds of operations on the existing data: You'll see how to get different kinds of reports about your data, how to update product catalog information, and how to search for products.
The product catalog presented in this case study creates the underlying database for a full-featured Web site. In this chapter, you'll concentrate exclusively on the database itself, and you'll have a lot of fun playing with the four data tables that make the simple catalog. This chapter explains all the steps in your journey for the databases covered so far in this book. These steps are as follows:
Create the data structures for the product catalog.
Populate the product catalog with sample data.
Analyze options for retrieving catalog information.
Analyze options for updating catalog information.
Search the product catalog.
| Note |
Because the different Relational Database Management Systems (RDBMSs) have different implementations of SQL, this chapter highlights any differences between code as appropriate. Note, though, that MySQL doesn't support nested queries or stored procedures, and Access has trouble running some of the JOIN statements presented in this chapter. |
|
|