Learn what database design elements to consider, as well as how to create an Access database, in this free lesson.
Watch the video! (4:22min)
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.
The store needs a way to keep track of these things.