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 ...
Get Sams Teach Yourself DB2® Universal Database™ in 21 Days, Second 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.
