1 / 25

Serenity Day Spa & Salon est. 2005

Serenity Day Spa & Salon est. 2005. Presented By: Angie Galjour Melissa Hall. Table of Contents. System Request Background Needs Requirements Value Added Issues & Constraints Entities Entities & Attributes Logical Design Physical Design Entity Relationship. System Request.

oprah
Download Presentation

Serenity Day Spa & Salon est. 2005

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Serenity Day Spa & Salonest. 2005 Presented By: Angie Galjour Melissa Hall

  2. Table of Contents System Request Background Needs Requirements Value Added Issues & Constraints Entities Entities & Attributes Logical Design Physical Design Entity Relationship

  3. System Request Project Sponsor Mr. Lucas (owner) Phone (281) 455-7734 Fax (281) 455-7735 Email Blucas@gmail.com

  4. Background Serenity specializes in both women and men hair cuts. Use appointment book and manual filing system.

  5. Needs • Provide additional services and products to generate income. • Incorporation of a database to do away with current manual filing system and paper trail.

  6. Requirements Implement computerized business system to record customer id’s, product a and service costs as well as appointment times and dates. Training of each employee on new database system.

  7. Value Added • Decrease paper usage within the company. • Will improve business efficiency therefore leading to happier customers. • Generate more revenue with new services added.

  8. Issues and Constraints • Time spent incorporating old paper files into new database. • Time and money spent on training the employees on new system. • Expenses incurred developing the new system.

  9. Entities Customer Appointment Services & Cost Invoicing Payment Types Payment Received Employees Employees Certification

  10. Entities & Attributes

  11. Entities & Attributes Continued

  12. Logical Design (E-R Diagram)

  13. Physical Design • Customer – Customer ID, Last Name, First Name, Phone #, Street, City, State, Postal Code • Appointment – Appointment ID, Customer ID, Employee ID, Appointment Date, Appointment Time • Appoint-Service- Appointment ID, Service ID • Services – Service ID, Service Type, Cost • Invoicing – Invoice ID, Appointment ID, Amount Billed • Payments – Payment ID, Invoice ID, Amount Paid, Date Paid, Payment Type • Employees – Employee ID, Last Name, First Name, Street, city, State Postal code • Employee-Certification -Employee ID, , Certification ID • Certification– Certification ID, Certification Type

  14. Entity Relationships

  15. Report 1

  16. Report 2

  17. Message Appointment Query

  18. Hair Technician Query

  19. Male Salon Services Provided July 30 Query

  20. Customer Appointment Form

  21. Employee Certification Form

  22. Service & Cost Form

  23. Main Switchboard

  24. View Form Switchboard

  25. Questions?

More Related