Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1.) State Transition Diagram for the Expert Tutoring Center Customer System. Expert Tutoring Center Customer System The Expert Tutoring Center provides tutoring sessions for customers

1.) State Transition Diagram for the Expert Tutoring Center Customer System.

Expert Tutoring Center Customer System

The Expert Tutoring Center provides tutoring sessions for customers in the Chicago suburbs. After a rigorous evaluation process, tut0rs 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 tut0rs 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 tut0rs with the requested subject expertise. When a tut0r accepts, the tutoring session is scheduled and the assigned tut0r 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 tut0r and covers only one subject.

When the session is complete the tut0r 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 Tut0r 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

Tut0r 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

Tut0r 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

Tut0r Total

4

Turing

Harris

00356

12/4 4:00 PM

Calculus

Getting better

Turing

Russell

00367

12/4 7:00 PM

Calculus

Needs practice

Tut0r Total

2

GRAND TOTAL

13

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

Session ID

. . .

Status

Tut0r 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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

Fingerprint evidence is admissible in court. Should it be?

Answered: 1 week ago