I need some help, I need to design the database relationship diagram with the
information given below. I have been asked to design an Access relational
database for a small bookstore that operates 3 stores. Books are sold by a
sales person to a customer through an order. An order may consist of one or
more books but assume that for a given order, all the books sold are all from
one store and are sold by one salesperson.
Field name                         Field description (additional info given if
needed)
Address                         Address of the customer
Author ID   
Author Name   
Book ID                         Unique id number for each book
Book type                       One of a number e.g. H for hard cover, S for
soft cover etc
Book type description   
City                        City the customer lives in
Country                         Country the customer lives in
Cust Id   
Cust Name   
Cust Type            One of a number of values such as: I for individual C for
Company
Cust Type Descr   
Email                          Email address of the customer
On hand                           The quantity on hand, of a given book in a
given store.
Order date   
Order No   
Phone no     Customer phone number. Note: The customer can have more than 1
phone no
Phone type                    One of a number: e.g. H for Home, C for Cell O
for Office etc
Phone type descr   
PostCde                    Customer postal code
Publisher ID   
Publisher Name   
Quantity                     For each book sold it identifies the quantity of
the                             same book (typically 1).
Salesperson Id   
Salesperson Name   
Salesperson Phone   
Selling price    The price can vary between stores as the the same book can be
sold in different stores
Store address   
Store City   
Store email   
Store No                    A value of 1, 2 or 3 representing the store number
Store Phone   
Title               Full title of the book