1 / 25

Econocuts

Econocuts. Celia Y Gomez Kristen Kozlowski Sandra Salvato. Contact Information. Phone: (281) 862-2887 Fax: (281)862-0754 E-mail: sales@econocuts.com . Business Background. Houston based discount lawn service In operation for over 15 years

maddox
Download Presentation

Econocuts

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. Econocuts Celia Y Gomez Kristen Kozlowski Sandra Salvato

  2. Contact Information Phone: (281) 862-2887 Fax: (281)862-0754 E-mail: sales@econocuts.com

  3. Business Background • Houston based discount lawn service • In operation for over 15 years • Provide quality lawn service at affordable prices • Provide multitude of services including: • Renovations • Fertilization • Landscaping • Lawn care

  4. Business Needs • Business information is being recorded manually • Need to track business cycles to monitor slow seasons • Increase sales by 20% • Better utilization of time and equipment • Inform customers of other services offered

  5. Business Requirements • Implement computerized business system to record accounting transactions and seasonal cycles • Advertise other services through fliers, additional information on invoices, signage on current projects and around neighborhoods serviced • Onsite repair technician for maintenance of equipment

  6. Business Value • Implementing Computerized business system would reduce office supplies expense, increase productivity, reduce office hours for manual record keeping • Increased advertising would increase sales of additional services available • Onsite repair technician would reduce equipment down time and repair costs

  7. Special Issues • Computerized system must be user friendly • Advertising should focus on services available during slow seasons • Repair technician should be cross-trained to assist as required in other areas of the business to reduce downtime

  8. Entities • Customer • Order • Services • Equipment • Employees • Skills • Maintenance • Invoices • Payments

  9. Entities and Attributes

  10. Entities and Attributes cont.

  11. Logical Design (E-R Diagram) 1 1 M 1 M M M 1 M 1 1 M M M 1 M

  12. Physical Design Customer (CustomerID, LName, FName, Address, City, ZipCode, Telephone) Order (OrderID, CustomerID, ServiceID, DateOrdered, EquipmentID) Invoices (InvoiceID, OrderID, AmountBilled, DateBilled) Service (ServiceID, Service Type, Cost) Payments (PaymentID, InvoiceID, AmountPaid, DatePaid, Balance) Employees (EmployeeID, LName, FName, SkillID, Address, City, ZipCode, Telephone) Skills (SkillID, SkillType) Maintenance (RepairOrderID, EquipmentID, EmployeeID, DateRepaired) Equipment (EquipmentID, Model Number, EquipmentType) Order Service (OrderServiceID, OrderID, ServiceID) Order Equipment (OrderEquipmentID, OrderID, EquipmentID)

  13. Entity-Relationships

  14. Report 1

  15. Report 2

  16. Customer Query for Houston

  17. Employee Query for Skill 2

  18. Order-Service Query

  19. Order-Equipment Query

  20. Customers information Form

  21. Employees Information Form

  22. Services Form

  23. Main Switchboard

  24. View Form Switchboard

  25. Questions?

More Related