|
|
Because this book is designed to explain how to construct SQL statements on numerous Relational Database Management Systems (RDBMSs), we decided that instead of using one of the database vendor standard databases (such as the pubs SQL Server database, for example), we'd use a custom database as the central example for this book.
The InstantUniversity sample database is designed to model a fictitious university, attended by students and professors, with courses, exams, and so on. Figure B-1 shows a visual model of the database.
Over the course of this appendix, you'll look through the design for each table in the database and the SQL code that's used to create each table. Finally, you'll look at some of the data used to populate the database. Where appropriate, we'll highlight differences between RDBMS-specific code.
| Note |
The code for creating this database is available for free download from the Downloads section of the Apress Web site (http://www.apress.com). |
|
|
