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 • 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
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.
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
Cost Estimates • Inputs • Car Make • Model • Year • Type • Service required • Outputs • Total amount with taxes
Work time & Parts location • Inputs • Car Make • Model • Year • Type • Service required • Specific parts’ name • Outputs • Estimated work time • Location of parts (with image)
Business Value • The following benefits are expected from the new system’s implementations. • Increased customers’ loyalty • Increased revenues • Faster service provided
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.
Database Model Part s Part ID (Primary Key) Part Number Name of Part Location of Part Customer Customer ID (Primary Key) Last Name First Name Address City State Zip code Phone Number Work Order ID Work Order Work Order ID (Primary Key) Date of Order Customer ID Car Make Year Model Part ID
Conclusion • Donations • Comments • Thoughts • Suggestions