O'Reilly logo

Sams Teach Yourself DB2® Universal Database™ in 21 Days, Second Edition by Susan Visser, Bill Wong

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

Chapter 8. Designing the CDLIB Database

Today you go through the steps of designing a database, tables, and referential constraints to hold the data for a CD collection. Today focuses on planning and designing a database structure; the actual creation of the database and its tables is covered tomorrow. Planning a database structure is as important as actually creating the database—in fact, good planning helps prevent hard-to-fix problems down the road.

I’ll take you through the usual steps for designing a database to show you the structure of the database for the CD collection. These steps include deciding what data to store in the database, choosing appropriate columns and data types, defining relationships between the tables, identifying the ...

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