Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

access problem

  • Please log in to reply



    New Member

  • Member
  • Pip
  • 1 posts
Help, 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
  • 0




    Visiting Staff

  • Member
  • PipPipPip
  • 624 posts
Are you asking for the database and the relationships to be mapped out for you?

You'll need several tables, depending on how normalized you want this thing...


Stores can have many employees, an employee can only have 1 store (assumption)
Stores can have many orders, an order can only come from 1 store (your constraint)
Employees can have many orders, an order can only come from 1 employee
A customer can have many order, an order can only go to 1 customer

You'll also need a bridge table between Order and Book. A Book can be on many Orders, an Order can have many Books. Your bridge might be something like Book Order.

You were sorta vague, so I hope this gives you a good starting point. If you want to get more complex, you can normalize down by splitting Publisher and Author off of the Book table and into their own.

Let me know if this was at all helpful.
  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP