1 / 10

ISAM 3332 GROUP PROJECT – Sp ‘10

ISAM 3332 GROUP PROJECT – Sp ‘10. Mansoor Iqbal Ansa Gul Maryam Malhi. Name and Sponsor of the company. Ihsan U. Malhi Advance Auto Service 6370 Antoine Dr. Houston, Texas 77091. Business Info.

newton
Download Presentation

ISAM 3332 GROUP PROJECT – Sp ‘10

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. ISAM 3332 GROUP PROJECT – Sp ‘10 Mansoor Iqbal Ansa Gul Maryam Malhi

  2. Name and Sponsor of the company Ihsan U. Malhi Advance Auto Service 6370 Antoine Dr. Houston, Texas 77091

  3. Business Info • Advance Auto Service is an independent setup providing most of the auto services in the neighborhood. • It includes the services: • Fuel Injection • Tune up • Transmission Service • Cooling System • Oil Change • Clutch Replacement • Shock & Struts • Front Ends • Brake Job • A/C Service • C/V Axles • Balance & Rotation • Tire Fixed & Sales • Computer Diagnostics

  4. Business Requirement The business requires a system which would include: • A database program that will provide its existing customers’ information and allow to create files for new ones. • A program that will provide the cost estimates for the services required. • A system that will allow to estimate work time, and locate the specific part of the car.

  5. Customer Information: • Inputs • Last name • First Name • Address, City, State, Zip • Phone Number • For existing customers, use only phone number • Email Address (optional) • Output • Existing Customer’s Profile • Save new customer’s information

  6. Cost Estimates • Inputs • Car Make • Model • Year • Type • Service required • Outputs • Total amount with taxes

  7. Work time & Parts location • Inputs • Car Make • Model • Year • Type • Service required • Specific parts’ name • Outputs • Estimated work time • Location of parts (with image)

  8. Business Value • The following benefits are expected from the new system’s implementations. • Increased customers’ loyalty • Increased revenues • Faster service provided

  9. Constraints/Issues of creating a database information system. • Systems are complex and difficult. • They are time-consuming to design. • System must cost less than $5,000.

  10. Conclusion • Donations • Comments • Thoughts • Suggestions

More Related