AuthorISBN Table
The AuthorISBN table (described in Fig. 24.7) consists of two columns that maintain ISBNs for each book and their corresponding authors’ ID numbers. This table associates authors with their books. The AuthorID column is a foreign key—a column in this table that matches the primary-key column in another table (that is, AuthorID in the Authors table). The ISBN column is also a foreign key—it matches the primary-key column (that is, ISBN) in the Titles table. A database might consist of many tables. A goal when designing a database is to minimize the amount of duplicated data among the database’s tables. Foreign keys, which are specified when a database table is created in the database, link the data in multiple tables. Together ...
Get Java™ How To Program (Early Objects), Tenth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
