C. T. S. Academic Center Case Study

Our client is the Arizona Wildcat Academic Center (abbreviate that by calling it C.A.T.S. Academics in the rest of report). The normal goal of C.A.T.S Academics is help student-athletes graduate and there are more than 500 student-athletes belong C.A.T.S Academics. Therefore, the department provides these students a good place to study and offer all possible academic supports and resources, such as tutoring services, to student athletes. This October, the department moved to a bigger building with more various purpose rooms and then want to hire more amounts of high-quality workers. They intend to specify the correct purpose of each room in this new building. In addition, they want to track Tutors, for examples, keeping records whether the tutor attends the tutoring appointments or not and the total number of working hours. Considered these new demands, they want to setup a new online booking & scheduling system. The mission of our team is to help C.A.T.S. Academics create a database system and front-end booking & scheduling procedure.

The main Users of system include: staffs (Administrators, Counselors, Front Desks, and Learning Specialists) and students. Based on their roles, these users will be able to access different features of the

Academics require make a variety of Bookings. Hence, there will be four types of Room Booking in the Booking Type: room reservation for self-studying, tutoring appointments to improve students learning skills, training sessions among the learning specialists and tutors, and special events that could block any rooms anytime. Also, they want to record the utilization of each room, and keep tracks of the users who reserve and check-in to each room in details. Student alone can make reservations for self-study purpose, however, student must talk to his/her counselor to make tutor appointments. The Bookings are composited to Booking Type. Each booking Type records the unique BookingType_ID and number of