1 / 24

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.

landon
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. USER INTERFACE

  11. Hierarchy Diagram Of The Form

  12. Login Screen

  13. Main Menu

  14. Forms

  15. Customer Form

  16. Work time and Parts Form

  17. Cost Estimate Form

  18. Reports

  19. Sales Report

  20. Inventory Report

  21. Profit/Loss Report

  22. 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

  23. Database Design

  24. Conclusion • Donations • Comments • Thoughts • Suggestions

More Related