Intro to Database Activity
Intuitive Table Design
Bookstore

Group Assignment:
A bookstore must, at a minimum, be able to purchase materials, dispose of materials, sell out materials, return materials.  Design a draft set of Entity Attribute tables for information that needs to be tracked by a bookstore. Remember that there are many and diverse queries that a customer might ask while looking for a book.
After you have drafted your tables, check for normalization.  Put your tables into third normal form.  Ask for help if you need it.