Question: Class Diagram for the system. (Do not include the temporary Weekly Records file.) Add 2-3 methods to one of the object classes. Make sure the

Class Diagram for the system. (Do not include the temporary Weekly Records file.) Add 2-3 methods to one of the object classes. Make sure the relationships are represented in the data.

The Expert Tutoring Center provides tutoring sessions for customers in the Chicago suburbs. After a rigorous evaluation process, tutors are hired to provide tutoring for one subject area. (The hiring process is outside the scope of the system you are documenting). In addition to subject area, other information recorded about tutors includes an ID, TLName, TFname, address, email, and phone.

A customer creates an account by providing first and last name (CLName), DOB (date of birth), email address, and phone number. The system assigns a unique customer ID (record number). The system displays a list of regional schools (SchNumber, name, and city) from the school file. The customer enters the SchNumber and this is recorded. For home schooled customers this field is left blank.

To register for a tutoring session the customer enters email address, the subject which will be covered in the session and the preferred date/time. At this time the tutoring session record is created and stored with a session ID and status of requested. The system sends this session request information to all tutors with the requested subject expertise. When a tutor accepts, the tutoring session is scheduled and the assigned tutor ID is added to the session record and the customer is notified. The customer can separately register for additional tutoring sessions for the same or different subjects. Each tutoring session is taught by one tutor and covers only one subject.

When the session is complete the tutor records the outcome and the status is changed to completed.

Every Sunday at 10 PM the system creates the Weekly Tutoring Report and sends it to the Managing Director. (Assume that the system has created a temporary file called Weekly Records that contains the fields shown below for the tutoring sessions for the past week, sorted by Tutor Last Name.)

Tutoring session records are stored in the system for 1 year and then moved to a data archive. After 10 years records are deleted from the archive.

Weekly Tutoring Report

T LName

C LName

Session ID

Date/Time

Subject

Outcome

Curie

Davies

00202

12/1 4:30 PM

Chemistry

Not studying

Curie

Riley

00216

12/1 6:00 PM

Chemistry

Improving

Curie

Davies

00287

12/2 4:30 PM

Chemistry

Hopeless

Curie

Firestone

00398

12/5 4:30 PM

Chemistry

Good progress

Tutor Total

4

Einstein

Riley

00209

12/1 4:00 PM

Calculus

Excellent

Einstein

Baker

00234

12/1 6:30 PM

Calculus

Excellent

Einstein

Baker

00301

12/3 5:00 PM

Calculus

Not prepared

Tutor Total

3

Hawking

Firestone

00203

12/1 4:30 PM

Physics

Good progress

Hawking

Rubble

00225

12/1 5:30 PM

Physics

Impossible

Hawking

Firestone

00268

12/2 2:30 PM

Physics

Trying

Hawking

McCarthy

00312

12/3 6:00 PM

Physics

Okay

Tutor Total

4

Turing

Harris

00356

12/4 4:00 PM

Calculus

Getting better

Turing

Russell

00367

12/4 7:00 PM

Calculus

Needs practice

Tutor Total

2

GRAND TOTAL

13

Here is a sample of some of the tutoring session data:

Session ID

. . .

Status

Tutor ID

Outcome

00456

Completed

Tu9873

Needs practice

00457

Completed

Ha3426

Excellent

00458

Scheduled

Ha3426

00459

Scheduled

Ei7777

00460

Requested

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!