Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Use Case Diagram for the Expert Tutoring Center Customer System. The Expert Tutoring Center provides tutoring sessions for customers in the Chicago suburbs. After

1. Use Case Diagram for the Expert Tutoring Center Customer System.

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

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

Recommended Textbook for

Fundamentals Of Database Systems

Authors: Sham Navathe,Ramez Elmasri

5th Edition

B01FGJTE0Q, 978-0805317558

More Books

Students also viewed these Databases questions

Question

Provide examples of KPIs in Human Capital Management.

Answered: 1 week ago

Question

What are OLAP Cubes?

Answered: 1 week ago