June 2017
Beginner
1296 pages
69h 23m
English
We introduce relational databases in the context of this chapter’s books database, which you’ll use in several examples. Before we discuss SQL, we discuss the tables of the books database. We use this database to introduce various database concepts, including how to use SQL to obtain information from the database and to manipulate the data. We provide a script to create the database. You can find the script in the examples directory for this chapter. Section 24.5 explains how to use this script.
Authors TableThe database consists of three tables: Authors, AuthorISBN and Titles. The Authors table (described in Fig. 24.3) consists of three columns that maintain each author’s unique ID number, first name and last name. ...