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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.