O'Reilly logo

Access 2002 Programming by Example by Bob Villareal

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 and Normalization

By now, you should know that a database is a collection of information related to a specific purpose. But how do you organize this information for maximum efficiency? A good database design is the key.

The table is the heart of the database. It is where most of your database work focuses either directly or indirectly. But just because you have several tables that relate to each other in your database doesn’t necessarily mean that they are ready for database functionality.

Considerations related to database design include

  • the purpose of the database

  • necessary tables and fields

  • necessary relationships between tables

  • how to avoid data redundancy

  • how to ensure data consistency

When you examine these considerations, ...

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