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 ...