O'Reilly logo

Java™ Oracle® Database Development by David J. Gallardo

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

Combining Data from Different Tables

An important part of designing a relational database is deciding how to divide data into different tables. We imagined a CD collection that we originally organized on index cards, one card per CD, which we wanted to put in a database. To do this, we created one table to hold information that applied to the CD as a whole and another table for information about the songs. We called the process of finding relationships and creating tables to model the data with minimal redundancy normalization. We found that this process leads to multiple small tables. An important consequence of this is that, in order to use the data, create reports, or perform analyses—or, in our example, to recreate the information that was ...

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