Thinking about Database Design

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

Determine the purpose of the database

The first step of designing a database is to determine the purpose of the database. What do we need it to do?

At Ready-2-Read, our customers will place orders for books. At the very least, we will want our database to track the books we sell, the customers we sell them to, and the date of each of the orders.

Purpose of Ready-2-Read DatabasePurpose of Ready-2-Read Database

The database will also be able to tell us where our customers live when we need to send them books or coupons. Additionally, we can use it to track our sales or to make a bestseller list to post in the store.