Database design

The purpose of this assignment is to show how your thought process changes after you learn the proper methodology for creating databases. You will compare this to a later assignment.

Given the following scenario write down a LIST OF TABLES AND COLUMNS for a Bookstore database. You will not need to use Access for this.

I sell books and would like to create a database for my books and transactions. At this time I am not keeping track of supplier information. Many times customers come in asking what books a special author has written. Other times the customer wants books from a certain publisher or even a particular genre. Some of my books are hard cover and some are soft cover. I do not have any digital books.

The purpose of this assignment is to show how your thought process changes as we progress through the course. 

What to submit:

A document with table names and columns. For example

Table1Name                                   Table2Name

column1   Primary Key               column1 Primary Key
column2                                       column2  Primary Key
column3                                       column3