Java Reference
In-Depth Information
AuthorID
FirstName
LastName
1
Paul
Deitel
2
Harvey
Deitel
3
Abbey
Deitel
4
Dan
Quirk
5
Michael
Morgano
Fig. 24.4 | Sample data from the Authors table.
Titles Table
The Titles table described in Fig. 24.5 consists of four columns that maintain informa-
tion about each book in the database, including its ISBN, title, edition number and copy-
right year. Figure 24.8 contains the data from the Titles table.
Column
Description
ISBN of the topic (a string). The table's primary key. ISBN is an abbrevia-
tion for “International Standard Book Number”—a numbering scheme
that publishers use to give every book a unique identification number.
ISBN
Title of the topic (a string).
Title
Edition number of the topic (an integer).
EditionNumber
Copyright year of the topic (a string).
Copyright
Fig. 24.5 | Titles table from the books database.
ISBN
Title
EditionNumber
Copyright
0132151006
Internet & World Wide Web How to
Program
5
2012
0133807800
Java How to Program
10
2015
0132575655
Java How to Program, Late
Objects Version
10
2015
013299044X
C How to Program
7
2013
0132990601
Simply Visual Basic 2010
4
2013
0133406954
Visual Basic 2012 How to Program 6
2014
0133379337
Visual C# 2012 How to Program
5
2014
0136151574
Visual C++ 2008 How to Program
2
2008
0133378713
C++ How to Program
9
2014
0133570924
Android How to Program
2
2015
0133570924
Android for Programmers: An App-
Driven Approach, Volume 1
2
2014
0132121360
Android for Programmers: An App-
Driven Approach
1
2012
Fig. 24.6 | Sample data from the Titles table of the books database .
 
Search WWH ::




Custom Search