O'Reilly logo

Sams Teach Yourself CGI in 24 Hours, Second Edition by Rafe Colburn

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

Database Design

As you can tell by now, the relational model is completely centered around tables. All data in a database is stored in tables, and all queries receive their results in tables. Therefore, when you’re thinking about how to organize your data, it’s important to think about how to group your data within tables. Here are some important rules that apply:

  • All data must be returned by the database in a tabular format.

  • Each field must contain a single value.

  • For the purposes of data integrity, every row must contain a value (or group of values) that uniquely identifies that row.

  • A relationship between two tables is represented by part or all of the data in a column. In other words, the column data that expresses a relationship must appear ...

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