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:
Create the database books.
If necessary, modify create_books.sql to work in your particular DBMS.
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 ...