Appendix B. Sample Applications

For illustrative purposes, the SQL discussed in this book is based on several sample applications:

Teams and Games

This application keeps track of games played by sports teams. Each game has two teams who play each other, at a specific location. One team is designated the home team, and the other, the away team.

Content Management System (CMS)

In the Content Management System, online content is stored and retrieved via lists, displays, and searches. Comments, keywords, and categories of content are implemented.

Discussion Forums

The Discussion Forum application manages discussion threads consisting of related posts by registered forum members.

Shopping Carts

Shopping Carts are orders for specific ...

Get Simply SQL now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.