AppendixVideo Store Sample Database

This appendix contains an overview of the video store sample database used in this book along with instructions for downloading and installing it so you can follow along as you read.

Overview of the Video Store Sample Database

The SQL and forms-based query examples used in this book are based on a database for a fictitious video store. The next section provides instructions for downloading a ZIP file that contains a Microsoft Access 2000 database for the video store as well as the SQL statements required to create the database objects and populate them with data using MySQL, Oracle, Microsoft SQL Server, and other SQL-based databases.

The following illustration presents the entity relationship diagram (ERD) ...

Get Databases DeMYSTiFieD, 2nd Edition, 2nd Edition now with O’Reilly online learning.

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