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 Lube Tire rotation Inspections /emissions Business Background

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

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

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

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

CUSTOMER • ORDER • SERVICES • INVOICES • PAYMENTS Entities

Entities and Attributes

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

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

Relationships

Report #1

Report #2

Form #1

Form #2

Query #1

Query #2

Tables and forms Switchboard

???Questions???

Elk’s Lube Express