SQL: Visual QuickStart Guide

Creating the Sample Database books

If you’re using Microsoft Access, simply open the file books.mdb. If you’re using a server DBMS, you must create books and then run an SQL script to build its tables and populate them with data. Listing A.1 shows an ANSI SQL script named create_books.sql that creates the tables and inserts rows into them. To create the sample database in a server DBMS, you perform these general steps:

1.	Create the database books.
2.	If necessary, modify create_books.sql to work in your particular DBMS.
3.	Run create_books.sql against books.

I’ll describe the specific steps for each DBMS that I cover in this book. As usual, I assume that you have the necessary permissions from your database administrator, that you can connect ...