The textbook uses three attractive and realistic case studies across all 21 chapters.
Each chapter ends with three student projects which progressively expand each case study. These can be assigned as practice homework or even as weekly assignments. All images, pages, classes, database scripts, and other material for each of the case studies are available for download.
Art Store Case Study
This case can be used to create the prototypical online storefront. It contains images (in six different sizes) for 301 different paintings created by 81 different artists. Each art work is categorized by genres and subject matter. This art work information can be used to create a purely informational site. If a storefront is desired, then the case contains customer and order information as well.
To the left (or below) you can examine the database schema for this case.
Share Your Travel Photos Case Study
This case can be used to create a quasi Web 2.0 style web site. This Share Your Travel Photo site will be one in which users can post/share their travel blogs and photos for other users’ enjoyment. It comes with over 80 photos, each in six different sizes. Several dozen sample posts are also included. Tables are provided to allow instructors to assign user reviews, favorites, etc.
Book Rep Customer Relations Management Case Study
This case allows an instructor to assign a private Intranet-style web application to his or her students. The data and images are meant to be used to construct a customer-relations management tool for salespeople for a large book publisher. An instructor could also use the data to instead construct a public information or e-commerce site instead.