Purpose: The case study is designed for Systems Analysis and Design, Systems Development, and Database courses. It aims to help students integrate their knowledge and apply it to developing a computer information systems solution for a small business.

Synopsis: Professor Bausley, a computer information systems professor, identifies a need for a computerized system at a local car detailing shop during a service appointment. She involves her Systems Analysis and Design undergraduate students in the project by taking them to the shop for interviews with the owner to gather requirements.

CASE

Professor Bausley receives a phone call from Walter Schultz, the owner of Foothills

Auto Spa. Mr$.$ Schultz stated he had a couple of questions about the Professor$$s

upcoming service appointment at the shop.

$"$Hi$,$ Mr$.$ Schultz. Sure, what do you need?" responded Professor Bausley.

"First, did you say you wanted the Ceramic Coating? Also, did you want the Interior

Scrubbing and Brushing, and did you Steam Cleaning?" asked Mr$.$ Schultz.

"I thought you had written all those details down when I talked to you last week,"

answered Professor Bausley. "Let me see if I can find my notes. Did my

appointment not get scheduled?"

"Well, yes and no$.$ To be honest, I didn't have anything to write with when I took

your service appointment request, but I thought I could remember everything. I

actually ended up forgetting about your appointment request until this morning

when I noticed the calendar didn$$t have an appointment for the $2$ PM hour block. I

apologize, and I will put a rush on it$,$ so you should get your confirmation email by

the end of the day."

$"$Ok$,$ I guess it is a good thing you remembered. I needed the following: exterior

wash and dry, vacuuming in the trunk, interior scrubbing and brushing, glass

cleaning, and paint claying."

"Thanks!" said Mr$.$ Schultz. "I need to figure out a better way to keep track of orders.

Things are just so busy, and I can't find the time to get everything organized."

"Well, if you are able to get my vehicle done in the next few days, I might be able to

help you develop a more efficient way to keep track of your service appointments,"

offered Professor Bausley.

"That's a deal. What do you have in mind?" asked Mr$.$ Schultz.

"I think some of the students in my Systems Analysis and Design course should be

able to develop an automated system which will help you with your customers and

service appointments. I can ask them to meet with you when my car is ready so

they can start to get an understanding of your business and the information you

need to maintain."

"Sounds great$--$thanks, again!" replied Mr$.$ Schultz.

Professor Bausley met with the CIS students later that week, and when they went to

pick up the professor$$s car, the students were ready to interview Mr$.$ Schultz and

start thinking of a system solution. After the meeting they compiled their notes and

developed the following detailed requirements.

FOOTHILLS AUTO SPA: DETAILED REQUIREMENTS

Foothills Auto Spa requires a computerized system to manage customer appointments for car detailing services. Detailed requirements include capturing customer information $($name$,$ phone number, email$),$ assigning unique customer numbers, offering service packages with set prices, allowing customers to choose detailing options $($interior$,$ exterior, or both$),$ calculating total prices based on additional fees and service selections, generating service orders with order numbers, dates, and total prices, creating user$-$friendly data entry$/$edit interfaces, developing daily reports for scheduled appointments, and generating weekly and monthly order review reports. Professor Bausley guided Systems Analysis and Design students through the development process, resulting in a completed and implemented system by the end of the semester.

Requirements for Systems Analysis and Design students:

I. In the Planning phase, complete the following:

$1.$ Identifying and selecting a new system.

a$.$ Information Systems Plan

$2.$ Build Baseline Project Plan

a$.$ Project Scope

b$.$ Proposed System

c$.$ Feasibility Assessment

d$.$ Management Issues

$3.$ Project Charter

$4.$ Gantt Chart