Database Answers Tanning Salons is Required !!!

Printer Printer-friendly version

Home Ask a Question Best Practice Careers Contact Us Data Models Search Site Map
Tanning Salons
 
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
  • Home Ask a Question Careers Contact us Data Models First Timers Search Site Map