Access 2007
Thinking about Database Design
Designing a Database
Watch the video! (4:22min)
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-Read Bookstore
The store needs a way to keep track of these things.