Thinking about Database Design

Learn what database design elements to consider, as well as how to create an Access database, in this free lesson.

Designing a database

The Ready-2-Read bookstore scenario

The best way to learn about designing a database is to jump right in to the process. Let's pretend we work for the Ready-2-Read bookstore, and we need to build a database for the store to use. Let's think about what we might need the database to do for us.

The following diagram shows that we have customers and sell books via orders, both in the store and online.

Ready-2-ReadReady-2-Read Bookstore

The store needs a way to keep track of these things.