O'Reilly logo

Practical SQL Handbook, The: Using SQL Variants, Fourth Edition by Sandra L. Emerson, Marcy Darnovsky, Judith S. Bowman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

One-to-Many Relationships

At this point we have structures for four tables in the bookbiz database: authors, titles, editors, and publishers. Some of the properties of each of the entities described by the tables have been specified, and a primary key has been identified for each table.

However, you may have noticed that certain important relationships among the data are not yet represented in the proposed design. For example, there's nothing in these four tables that tells you about the connection between a particular publisher and the books it puts out.

The relationship between publishers and books can be described as one-to-many: Each book has only one publisher, while each publisher can produce many books. One-to-many relationships among ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required