The Area being Modelled is :-
Tanning Salons

A. This is a Statement of the User Specifications.

Hello,

I am new to access, I was referred to your web site can you help me or make a database for my business ?
Here�s what it needs it to do if possible. If it cant be done would you please let me know?

Thank you, have a great day!

Mary

This is the start of Mary's Specifications

Access Database:

1. Customers:

 
1.1 personal information
 
1.2 tanning packages
 
1.3 sessions
         i. expiration (packages have 3 months)
        ii. 1 month unlimited
       iii. 2 week unlimited

which bed they used and how long was their session.


Sales History


2. Daily Sales (each day with date)

packages
single sessions
purchases
lotion
        i.      bottle
                1. name of lotion
                2. price
                3.     cost

       ii.      package or shot of lotion
                1. name of lotion
                2. price
                3. cost

Miscellaneous Items
        i. what it is
       ii. price
      iii. cost

which employee sold it to them
Total for day
Tanning packages or single session sales
Lotion or product sales
Total of cash, credit card, check

Bulb hours
Bulb hours (different bulbs has different total hour usage)
        i. Used time Per bed
       ii. Time left Per bed

Inventory
Name
Price
Quantity
payment type
cash
check
credit card
employees
name
     i.      info
    ii.      days worked

3. Monthly  sales  reports

Tanning packages or single session sales
Lotion or product sales
Total of cash, credit card, check
This is the end of Mary's Specifications



B. The Things of Interest, ('THINGS'), include :-
B.1 To be determined.

C. These THINGS are Related as follows :-
C.1 To be determined.

D. Other Characteristics of these THINGS include :-
D.1 To be determined.

E. Sample Data includes :-
E.1 To be determined.

F. Typical Enquiries include :-
F.1 To be determined.

Barry Williams
March 6th. 2010
Principal Consultant
Database Answers Ltd.
London, England