The SD Coffee Company

1
The SD Coffee Company

• Your Name, Date, and Course Goes Here

2
Todays Meeting

• Sarah Davis created the SD Coffee Company to
  deliver coffee and supplies to small and medium
  businesses. The company has prospered but all
  data entry and reporting is currently on a manual
  basis. Sarah has commissioned an Access database
  to automate her company. Our purpose today is to
  discuss the preliminary design of that database.

3
The Relationships

• One-to-many relationship between sales reps and
  customers one sales rep can have many customers,
  but a given customer always works with the same
  sales rep
• One-to-many relationship between customers and
  orders one customer can have many orders, but a
  specific order is associated with one customer.
• Many-to-many-relationship between orders and
  products this requires the creation of another
  table that contains the primary key of both the
  Orders and Products tables

4
The Design
5
Information from the Database

• Query What is the total amount of a specific
  order?

• Solution

6
Information from the Database

• Query Which sales representative received credit
  for a specific order?
• Solution

7
Information from the Database

• Query Which customers ordered a specific
  product?
• Solution

8
A Contract Between You and Your Professor

• Your presentation becomes a contract between you
  and your professor with respect to the database
  design. Additional requirements will be specified
  later.
• The completed system must be able to add, edit,
  or delete any object through a form
• The completed system must be capable of creating
  your sample queries which in turn reflect any
  changes to the data