1 / 20

Elk’s Lube Express

Elk’s Lube Express. Jeremy Miller Brandon Rich Roxana Berrondo. Contact Information. Phone: (281) 232-LUBE Fax: (281) 233-LUBE Email: elklubeexpress@yahoo.com. Located in South Houston, Texas Have been providing superior car care for over 10 years Services offered Oil change

kynton
Download Presentation

Elk’s Lube Express

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. Elk’s Lube Express Jeremy Miller Brandon Rich Roxana Berrondo

  2. Contact Information Phone: (281) 232-LUBE Fax: (281) 233-LUBE Email: elklubeexpress@yahoo.com

  3. Located in South Houston, Texas Have been providing superior car care for over 10 years Services offered Oil change Lube Tire rotation Inspections /emissions Business Background

  4. Need an information system to: • Keep track of customer information to inform special offers and services • Have accurate count of inventory • Monitor sales and purchases Business Needs

  5. Implement a computerized system to record customer information, transactions, and inventory • Track progress of employees • Advertise all services offered through business invoices • Additional advertising would inform customers about all of the services we offer which would result in increased sales Requirements

  6. Reduce overall hours for time consuming manual record keeping • Employ computerized business system that will reduce all expenses due to inconsistent planning and accounting. • Generate more revenue with less down time, through tracking of peak operating times Business Value

  7. Our computerized system must be user friendly and reliable • Special offers should be shown on invoices • Incurred expenses with the development of the new information system • Focus on peak operating times Special Issues and Constraints

  8. CUSTOMER • ORDER • SERVICES • INVOICES • PAYMENTS Entities

  9. Entities and Attributes

  10. Payment 1 Invoice 1 1 Is made on Is made 1 1 M Customer Order Makes M Services 1 Requires Logical Design

  11. Customer ( Customer ID,LastName, FirstName, Address, City, Telephone) • Order ( Order ID, Customer ID, Service ID, Car Type, Date ) • Service ( Service ID, Order ID, Service Type, Cost) • Invoices( Invoice ID, Order ID, Amount Billed, Date Billed) • Payments (Payment ID, Invoice ID, Amount Paid, Date Paid) Physical Design

  12. Relationships

  13. Report #1

  14. Report #2

  15. Form #1

  16. Form #2

  17. Query #1

  18. Query #2

  19. Tables and forms Switchboard

  20. ???Questions???

More Related