Pet Grooming Service

 

 

 

 

 

 

 

 

Assignment:              Phase 1

 

Group Members:      Andy Hund,

Damon Green,

Fahd Khan,

Ka Lor,

Sharon Springorum

 

Due:                          November 4, 2003

 

Course:                     CSCI 273

 

Instructor:                Dr. Melody Stapleton


Table of Contents

 

            Background............................................................................................................... 3

            Requirements Specification........................................................................................ 3

            Entity-Relationship Model.......................................................................................... 4

            Object Model Diagram.............................................................................................. 5

            User Views............................................................................................................... 6

            Data Dictionary....................................................................................................... 26

            Use Case Diagram................................................................................................... 29

            Use Cases............................................................................................................... 30

            Use Case Scenarios................................................................................................. 34

            State Transition Diagram.......................................................................................... 62

            Appendix I (group members’ contributions).............................................................. 66

           


Background

 

In today’s world time is precious.  Everyone’s schedule is very busy and time management is very important.  To run a successful business resources must be managed efficiently, so your clients can use your services and still get on with the rest of their schedule.  If you offer services others in your field don’t offer, and you can make the best use out of you clients time, your client base will grow and your business will become more successful.

 

The business we have chosen to model is a pet grooming service.  We want to offer a grooming service that runs efficiently, where clients can schedule appointments on their own time.  The service must be very organized so clients can squeeze their pet grooming into their busy schedule.  To make this business successful we are going to build a scheduling database to keep track of all clients, their pets, and appointments all centered around a web based front end.

 

Requirements Specification

 

The requirements of the project are based around five different objects. 

 

1.      The client:  The client is the most important object in the system.  The system must have a simple and accessible interface for the client to use at his or her convenience.  The system will need to keep track of the client’s information so a client can drop off a pet without filling out forms each time.  The billing information for each client will also be maintained by the system.

2.      The pet:  Each client’s pet needs to have all pertinent information stored about them.  Any information that is important about the pet must be stored.  This will insure that the client can drop off the pet and be assured that the proper grooming will be given to the type of animal.  Identification information about each pet should also be stored.

3.      Appointments:  The system will allow clients to easily create and reschedule appointments.  This will be done in a web based fashion so that clients who may be at work during normal operating hours may schedule appointments when it would be convenient for their schedule.  The system will also keep a history of past appointments, so clients can be notified when a particular grooming service is needed again.

4.      Services:  The system will keep track of all services rendered.  It will store which services are appropriate for which animals.  It will keep track of the recommended service intervals for each service.

5.      Employees:  Information on employees will be kept so that each service rendered will be associated with the employee that rendered it.  All appropriate information should also be kept by the system.  The appropriate access permissions each employee has will be kept and enforced by the system.  The system should allow employees to work efficiently and all interfaces should be easy to use.

Entity-Relationship Model


Object Model Diagram


User Views

 

Name

 Add Employee

View Number

1

Type

Form

Description

This view is opened by the main menu selection. It allows the employee to enter in data for a new customer. At the buttons it will allows the user to scan through information of difference customers.

 

 


 

Name

 Update Employee

View Number

2

Type

Form

Description

This view is opened by the main menu selection. It allows the employee to enter in data for a current customer. At the buttons, it will allow the user to update information of difference customers.

 

Name

 Generate Schedule Report

View Number

3a

Type

Form

Description

This view is opened by clicking report from the main menu. It allows the employee to select the available report from a list. 

 

 

Name

 Generate Schedule Report

View Number

3b

Type

Form

Description

This view is opened by the 3a menu, it allow user to enter in specific date and time for schedule to be generate.

 

 


 

Name

 Generate Schedule Report

View Number

3c

Type

Form

Description

This view is opened 3b. It allows the employee to view specific data that was generated by the view 3b query.  It will display as a table form and show all the available time and appointment time on certain days. It allows employee to be able to print the schedule.

 

 


 

Name

 Add Product

View Number

4a

Type

Form

Description

This view is opened by the main menu selection. It allows the employee to select if user wants to add new product or the existing product.  It allows user to select either merchandize or service.

 

 

 


 

Name

 Add Product: Merchandise

View Number

4b1

Type

Form

Description

This view is opened by 4a selection. It allows the employee to add new information about merchandise.  Employee can add and save the information into merchandise profile.

 

 

 


 

Name

 Add Product: Service

View Number

4b2

Type

Form

Description

This view is opened by 4a selection. It allows the employee to add new information about service.  Employee can add and save the information into service profile.

 

 

 


 

Name

 Update Product

View Number

5a

Type

Form

Description

This view is opened by the main menu selection. It allows the employee to select if user wants to add new product or the existing product.  It allows user to select either merchandize or service.

 

 

 


 

Name

Update Product: Merchandise

View Number

5b1

Type

Form

Description

This view is opened by 5a selection. It allows the employee to update new information about merchandise.  Employee can update and save the information into merchandise profile.

 

 

 


 

Name

 Update Product: Service

View Number

5b2

Type

Form

Description

This view is opened by 5a selection. It allows the employee to update new information about service.  Employee can update and save the information into service profile.

 

 

 

Name

Log In

Number

6

Type

Form

Description

This form allows the user to enter username and password.  If is available by clicking file->log-in.

 

 


 

Name

Main Application

Number

7

Type

Multiple Document Interface

Description

This is the main application and allows access to other features by clicking on the main menu bar.

 

 

Name

Process Payment

Number

8

Type

Form

Description

This form allows an employee to look up a clients balance and apply payments to that balance.

 

 


 

Name

Schedule Appointment

Number

9

Type

Form

Description

This form allows an employee to schedule and appointment for a client.

 

 

Name

Unpaid Invoice Report

Number

10

Type

Form

Description

This report will display all the unpaid invoices given a specific date range.

 

 


 

Name

Add/Update Available Appointments

Number

11

Type

Form

Description

This form allows an employee to open and close appointment slots.

 

 

Name

Peak Appointment Report

Number

12

Type

Form

Description

This form allows an employee to display a report of the most popular appointment times.

 

 


 

Name

Add Customer

Number

13

Type

Form

Description

This form allows an employee to add a customer to the database.

 

 


 

Name

Update Customer

Number

14

Type

Form

Description

This form allows an employee to update a customers information.

 


Name

Add Pet

Number

15

Type

Form

Description

This form allows an employee to add a pet to a client.

 

 


 

Name

Update Pet

Number

16

Type

Form

Description

This form allows an employee to update the information about a pet.

 


 

Name

Cancel Appointment

Number

17

Type

Form

Description

This form allows an employee to cancel a clients appointment.

 

 


 

Name

Update Invoice

Number

18a

Type

Form

Description

This form allows an employee to choose which invoice needs to be updated.

 

 


 

Name

Update Invoice: Add/Delete Product

Number

18b

Type

Form

Description

This form allows an employee add or remove lines from the invoice.

 


Data Dictionary

         

          User

                  uName             varchar(20)        PK, RQ’d            User’s user name

                  password         varchar(20)        RQ’d                   User’s password

                  lName              varchar(20)        RQ’d                   User’s last name

                  mName            varchar(20)                                    User’s middle name

                  fName              varchar(20)        RQ’d                   User’s first name

                  street                varchar(30)                                    User’s street address   

                  city                   varchar(20)                                    User’s city

                  state                 varchar(2)                                      User’s state

                  zip                    varchar(10)                                    User’s zip code

                  phone               varchar(14)                                    User’s phone number

 

            Customer

                  custId               smallint               PK, RQ’d            Customers identification #

                  e-mail               carchar(30)                                    Customer e-mail address

                  uName             varChar(20)       FK, RQ’d            Foreign key to user table

 

            Employee

                  empID              smallint               PK, RQ’d, FK     Employee’s identification #

                  birthDate          date                    RQ’d                   Employee’s birth date

                  hireDate           date                    RQ’d                   Employee’s hire date

                  adminLev         smallint               RQ’d                   Employee’s administration level

                  jobTitle             varChar(10)       RQ’d                   Employee’s job title

 

            Creates

                  appID              smallint               PK, FK, RQ’d     Foreign key to appointment table

                  uName             varchar(20)        PK, FK, RQ’d     Foreign key to user table

                  method             varchar(10)        RQ’d                   Method appointment was made

                  createDate        date                    RQ’d                   Date appointment was created

 

            Appointment

                  appID              smallint               PK, RQ’d            Appointment identification #

                  slotNum           smallint               RQ’d                   Appointment # for particular hour

                  date                  date                    RQ’d                   Date for the appointment

                  time                  time                    RQ’d                   Time of the appointment

 

            Invoice

                  invID                smallint               PK, RQ’d            Invoice identification #

                  status                varchar(10)        RQ’d                   Invoice’s current status

                  balance             float                    RQ’d                   Invoice’s balance due

                  reminder           date                                                Date to e-mail customer reminder

                  petId                smallint               FK, RQ’d            Foreign Key to pet linked to invoice

                  appID              smallint               FK, RQ’d            Foreign key to appointment time

 

            Pet

                  petID               smallint               PK, RQ’d            Pet’s identification #

                  name                varchar(20)        RQ’d                   Pet’s name

                  birthDate          date                                                Pet’s birth date

                  notes                varchar(200)                                  Note’s about pet

                  animal               varchar(10)        RQ’d                   Type of animal

                  color                varchar(10)        RQ’d                   Pet’s color

                  breed               varchar(10)        RQ’d                   Pet’s breed

                  custID              smallint               FK, RQ’d            Foreign key to pets owner

 

            Line_Item

                  lineNumber       smallint               PK, RQ’d            Line item line number

                  invID                smallint               PK, FK, RQ’d     Foreign key linked to invoice

                  quantity            smallint               RQ’d                   Quantity of products for line

                  prodID             smallint               FK, RQ’d            Foreign key linked to products

                  lineTotal           float                    RQ’d                   Line Total

 

            Product

                  prodID             smallint               PK, RQ’d            Products’ identification #

                  name                varchar(20)        RQ’d                   Product’s name

                  cost                  float                    RQ’d                   Product’s cost

                  type                  varchar(1)          RQ’d                   Specifies service or merchandise

                  duration            smallint                                           How long it takes to perform service

                  interval             smallint                                           Time till next grooming service

                  active               bool                                               Active status for service

                  empID              smallint               FK                       Foreign key link to employee

                  numRemain       smallint                                           Remaining inventory

 

PK-Primary Key, RQ’d – Required, FK – Foreign Key

 

User Views

      Add Employee                           1      Form    Allows new employees to be added to database.

      Update Employee                       2      Form    Allows employee information to be updated.

      Generate Schedule Report          3a    Form    Displays the appointment schedule.

      Add Product                              4a    Form    Chooses which type product to add.

      Add Product: Merchandise         4b1  Form    Adds merchandise to database.

      Add Product: Service                 4b2  Form    Adds services to database.

      Update Product                          5a    Form    Chooses which type product to update.

      Update Product: Merchandise     5b1  Form    Updates merchandise in database.

      Update Product: Service             5b2  Form    Updates services in database.

      Log In                                        6      Form    Allows user to log on to system.

      Main Application                        7      MDI     Main application allows access to other views.

      Process Payment                        8      Form    Allows employee to take client payment.

      Schedule Appointment                9      Form    Allows employee to schedule an appointment.

      Unpaid Invoice Report                10    Form    Allows access to display invoice report.

      Add/Update Available App.       11    Form    Allows time slots to be added/updated.

      Peak Appointment Report          12    Form    Allows access to peak appt. report.

      Add Customer                            13    Form    Allows employees to add customer to database.

      Update Customer                       14    Form    Update existing customers in the database.

      Add Pet                                     15    Form    Allows employees to add pet to database.

      Update Pet                                 16    Form    Update existing pets’ information in database.

      Cancel Appointment                   17    Form    Allows employees to cancel a set up appt.

      Update Invoice                           18a  Form    Selects which invoice to update.

      Update Invoice:Add/Delete         18b  Form    Updates individuals lines on invoice.

 


Use Case Diagram


Use Cases

Use Case

Login

Actor(s)

Company Employees, Existing, and Prospective Clients

Description

 

Both company employees and company clients, new and existing, have the option of dialing in to the company web page to schedule an appointment for a pet.  If it is a new client, the system will prompt the customer for information regarding creating a new account.  Once the account has been created, the customer will be asked to log on using the newly created user name and password.  If the user is an existing client/employee, the system will prompt for a user name and password and proceed to the scheduling option.

 

Use Case

Add/Update Clients

Actor(s)

Company Employees, Existing, and Prospective Clients

Description

 

Company employees have the option to create a new account for a client once they have logged in.  This option is mainly for clients who do not make use of the web service and are simply walk-ins or customers who have phoned in.  Client information may be updated by employees as well as by customers.  There will be some restrictions on what information can be updated – such as customer numbers, changing a pet’s name.

 

Use Case

Process Payment

Actor(s)

Company Employee

Description

 

Once a pet has completed a scheduled appointment and invoice will have been generated for the transaction.  The invoice will have a status assigned to it – open, closed, pending etc.  Only once the full payment has been processed on an invoice will it be flagged as paid.

 


 

Use Case

Schedule Appointment

Actor(s)

Company Employees, Existing, and Prospective Clients

Description

 

After the user has logged in they can select the date on which the grooming service is to be performed.  The system will list the available appointment times for that particular day.  Once the appointment has been scheduled, the system will be able to email the customer as a reminder if an email address is in the database for the customer.  At the same time as the appointment is scheduled an invoice shell will be generated by the system and have a status assigned to it.

 

Use Case

Add/Update Pet

Actor(s)

Company Employees, Clients

Description       :

 

Company employees have the option to create a new pet account if the pet is coming first time to the pet grooming company. The pets have a lot of information stored on them like name/ID, weight, color etc. If this information needs to be updated it can be done by any employee or client.

 


 

Use Case

Add/Update Products

Actor(s)

Company Owner

Description

 

The Pet Grooming Company offers a number of different products including services, and merchandise.  An authorized employee can add a new product or update an existing one.

 

Use Case

Cancel Appointment

Actor(s)

Company Employees

Description

 

If a customer does not show up for an appointment, then the status of the corresponding invoice for that appointment has to be set to canceled by the employee. The employee can also cancel an invoice; if the customer cancels the appointment the system will mark that appointment as available and changed status of invoice.

 

Use Case

Update Invoice

Actor(s)

Company Employees

Description           

When a customer makes an appointment on the web site or through an employee, an invoice is automatically generated. This status of this invoice is set to ‘open’ meaning that the information on the invoice can be changed or more information can be added to it. When the day of the appointed is reached and after the services on the pet/pets have been performed, the employee can update the invoice with product charges and mark invoice as closed.

 

 

Use Case

Email Client’s Reminder Report

Actor(s)

System

Description

At close of business the system will generate a report of the clients whose pets are due for a service.  The system will use that report to e-mail a reminder to each client to schedule an appointment to have their pet groomed. 

 


 

Use Case

Add/Update Employee

Actor(s)

Company Owner

Description

Owner login success to the database.  The owner has that ability to add new employees to the database, or update the employee’s information.

 

Use Case

Generate Schedule Report

Actor(s)

Employee

Description

An employee may generate a schedule of all open and taken appointments.  The employee will be able to choose the range of dates that the report will generate.

 

Use Case

Peak Appointment Time Report

Actor(s)

Company Employees

Description

This report can be generated by any employee.  It will list the most popular and the least popular appointment times.  This report will help the employees set up future schedules.

 

Use Case

Unpaid Invoice Report

Actor(s)

Company Employees

Description

This report will generate a list of all invoices that currently have a balance due of not zero.  This report can be generated for a specific time range.

 

Use Case

Add/Update Available Appointments

Actor(s)

Company Employees

Description

Allow the employees to modify the appointment schedules.

 


Use Case Scenarios

 

Login

 

Scenario 1:

 

User enters correct username in username box.

User enters correct password in password box.

User presses “Log In” button.

System logs user on and displays main application.

 

            Event Trace:

 

           

 

Scenario 2:

 

User enters correct username in username box.

User enters incorrect password in password box.

User presses “Log In” button.

System displays “Invalid Username/Password”.

System redisplays logon form.        

 

           


Event Trace:

           

           

 

Process Payment

 

Scenario 1:

 

                  Employee selects payment from the customer menu on the menu bar.

                  Employee selects the customers name in the name combo box.

                  System retrieves and displays the total due from any unpaid invoices.

                  Employee enters the amount taken from customer.

                  Employee presses the apply amount button.

                  System applies amount paid to unpaid invoices starting with oldest.

                  System prints a receipt for the payment including any balance due.

 


Event Trace:

 

 

Scenario 2:

 

                  Employee selects payment from the customer menu on the menu bar.

                  Employee selects the customers name in the name combo box.

                  System retrieves and displays total due, total due is $0.00.

                  Employee presses the cancel button.

 


Event Trace:

 

 

 


Schedule Appointment

 

Scenario 1:

 

Employee selects create appointment from appointment menu.

System displays appointment form.

Employee selects customer from combo box.

System finds customers pets and fills in pet combo box.

Employee selects pet from combo box.

Employee selects service type from combo box.

Employee selects date for appointment.

System finds available appointments and fills in time combo box.

Employee selects appointment time.

Employee pressed OK button.

System schedules appointment for pet.

 

Event Trace:

 

 

Scenario 2:

 

Employee selects appointment from customer menu.

System displays appointment form.

Employee selects customer from combo box.

System finds customers pets and fills in pet combo box.

Employee selects pet from combo box.

Employee selects date for appointment.

System displays no available appointment times.

System allows employee to enter new appointment date.

 

            Event Trace:

           

 

Peak Appointment Time Report

 

            Scenario 1:

           

                        User selects the Reporting Menu from the Menu Bar

                        User selects Peak Appointment Report from the Reporting Menu

                        User enters Start Date

                        User enters End Date

                        User clicks on the OK button

                        System gathers and generates the required report

System prints the report

                        System returns to the Main Menu Bar

 

           


Event Trace:

           

 

Scenario 2:

 

                        User selects the Reporting Menu from the Menu Bar

User selects Peak Appointment Report from the Reporting Menu

                        User enters an out of range Start Date

                        User enters End Date

                        User clicks on the OK button

                        System generates and displays an error message

System redisplays the data form

User enters Start Date

                        User enters End Date

                        User clicks on the OK button

                        System gathers and generates the required report

System prints the report

                        System returns to the Main Menu Bar

 

           


Event Trace:

 

 

Scenario 3:

 

                        User selects the Reporting Menu from the Menu Bar

                        User selects Peak Appointment Report from the Reporting Menu

                        User enters Start Date

                        User enters End Date

                        User clicks on the Cancel button

                        System returns to the Main Menu Bar

 

           


Event Trace:

           

           

 

 

 


Unpaid Invoice Report

 

            Scenario 1:

 

                        User selects the Reporting Menu from the Menu Bar

User selects Unpaid Invoice Report from the Reporting Menu

                        User accepts default report settings – Print all Unpaid Invoices                                                  User clicks on the OK button

                        System generates the required report and prints it out

                        System returns to the Main Menu Bar

 

            Event Trace:

 

 

Scenario 2:

 

User selects the Reporting Menu from the Menu Bar

User selects Unpaid Invoice Report from the Reporting Menu

                        User clicks on From/To Specific Dates radio button

                        User enters Start Date

                        User enters End Date

                        User clicks on the OK button

                        System generates the required report and prints it out

                        System returns to the Main Menu

 

            Event Trace:

 

Scenario 3:

 

User selects the Reporting Menu from the Menu Bar

User selects Unpaid Invoice Report from the Reporting Menu

                        User clicks on From/To Specific Dates radio button

                        User enters Start Date

                        User enters an out of range End Date

                        User clicks on the OK button

                        System displays error message

System re-displays the data form

User clicks on From/To Specific Dates radio button

                        User enters Start Date

                        User enters End Date

                        User clicks on the OK button

                        System generates the required report and prints it out

                        System returns to the Main Menu Bar

 

           


Event Trace:

 

 


Add/Update Available Appointments

 

            Scenario 1:

 

User selects Appointment from the Main Menu Bar

                        User selects Amend Available Appointments

User enters Date

                        User enters Appointment Time

                        User enters Appointment Slot ID number

                        User clicks on the OK button

                        System displays message stating appointment slot is now available

                        System returns to the Main Menu

 

Event Trace:

           

 

            Scenario 2:

 

User selects Appointment from the Main Menu Bar

                        User selects Amend Available Appointments

User selects Unpaid Invoice Report from the Reporting Menu

                        User enters Date

                        User enters Appointment Time

                        User enters an invalid Appointment Slot ID number

                        User clicks on the OK button

                        System displays an error message and prompts user to re-enter an

Appointment Slot ID

 

      Add Customer

 

               Scenario 1:

 

                     User wishes to add a new customer.

                     User clicks CUSTOMER→ADD.

                     System displays the Add Customer Form.

                     User enters all known fields (including all required fields).

                     User clicks Add Customer.

                     System adds customer.

 

               Event Trace:

 

               Scenario 2:

 

                     User wishes to add a new customer.

                     User clicks CUSTOMER→ADD.

                     System displays the Add Customer Form.

                     User enters all known fields (including all required fields).

                     User clicks Add Customer.

                     System responds with [ERROR: username unavailable, try again]

                     User enters new username into form.

                     User clicks Add Customer.

                     System adds customer.

 

      Update Customer

 

               Scenario 1:

 

                     User wishes to update a customer’s profile.

                     User clicks CUSTOMER→UPDATE.

                     User selects Customer’s name from list.

                     System brings up editable customer profile form.                                                                                User edits any fields that require updating.

                     User clicks Update Customer.

                     System updates customer.

 

               Event Trace:     

 

               Scenario 2:

 

                     User wishes to update a customer’s profile.

                     User clicks CUSTOMER→UPDATE.

                     User selects Customer’s name from list.

                     System brings up editable customer profile form.

                     User clicks Cancel.

 

Add Pet

 

               Scenario 1:

 

                     User wishes to add a new pet.

                     User clicks CUSTOMER→ADD PET.

                     User selects Customer’s name from list.

                     System displays the Add Pet Form with customer’s profile.

                     User enters Pet name, and other required pet data.

                     User clicks Add Pet.

                     System adds pet to selected customer’s profile.

 

               Event Trace:

 

               Scenario 2:

 

                     User wishes to add a new pet, but new customer.

                     User clicks CUSTOMER→ADD PET.

                     User selects New Customer.

                     System displays the Add Customer Form.

                     User enters all known fields (including all required fields).

                     User clicks Add Customer.

                     System adds customer, and pet(s).

                    

Update Pet

 

               Scenario 1:

 

                     User wishes to update a pet’s profile.

                     User clicks CUSTOMER→UPDATE PET.

                     User enters Pet name, and selects Customer’s name from list.

                     System confirms pet and brings up editable Pet Profile Form.                                                                          User edits any fields that require updating.

                     User clicks Update Pet.

                     System updates pet.

               Event Trace:

                    

                Scenario 2:

 

                     User wishes to update a pet’s profile.

                     User clicks CUSTOMER→UPDATE PET.

                     User enters Pet name, and selects Customer’s name from list.

                     System confirms customer, but pet not found.

                     User selects pet from list of customer’s pets.

                     System brings up editable Pet Profile Form.                                                                                                    User edits any fields that require updating.

                     User clicks Update Pet.

                     System updates pet.

 

Cancel Appointment

 

Scenario 1:

 

Employee selects Appointment form from main menu.

System Displays Appointment form.

Employee selects cancel appointment.

System Displays Cancel Appointment form.

User enters correct customer name, pet name, appointment time and date.

User presses “ok” button.

 

Event Trace:

 

Scenario 2:

 

Employee selects Appointment form from main menu.

System Displays Appointment form.

Employee selects cancel appointment.

System Displays Cancel Appointment form.

      User enters Incorrect Customer name.

      System displays error message and redisplays cancel appointment form.

 


Event Trace:

 

   Update Invoice

 

Scenario 1:

 

                  Employee selects Invoice from the main menu.

                  System displays Invoice form.

                  Employee selects Update Invoice form.

                  System displays Update Invoice form.

                  Employee enters correct customer name, pet name, appointment time and date.

                  Employee presses ‘ok ‘ button.

                  System displays Update Product form.

                  Employee enters correct product name and number.

                  Employee presses ‘add product’ or ‘Delete product’ button.

                  System retrieves product information and adds / deletes products from Line-Item.

                  System redisplays Update product form if more products need to be add/deleted.

                  System displays message Update invoice complete.

 


Event Trace:

                 

                 

Scenario 2:

 

                  Employee selects Invoice from the main menu.

                  System displays Invoice form.

                  Employee selects Update Invoice form.

                  System displays Update Invoice form.

                  Employee enters correct customer name, pet name, appointment time and date.

                  Employee presses ‘ok‘ button.

                  System displays Update Product form.

      Employee enters incorrect product name and number.

       System displays an error and redisplays Update product form.

       


Event Trace:

 

Email Customers Reminder Report

 

Scenario 1:

 

Employee selects E-mail customers Reminder Report from main menu.

System checks reminder dates from Invoice table.

System returns Pets ID’s, which need to be scheduled for appointment.

System retrieves customer’s ID’s from Pet table.

System uses customers’ ID’s to retrieve customers’e-mail addresses.

System E-mails customers appointment reminders.

System displays Customer names, Customer ID and pet ID to whom e-mails were                      sent.

 

           


Event Trace:

           

 

Add Employee

 

Scenario 1:

 

The user wished to add employee

Window prompt for add query

The user enter employee data

The user submit data to add employee into profile

The employee file is added

 

           


Event Trace:

 

Update Employee

 

Scenario 1:

 

The user wishes to update new information about employee

Window prompts for update query.

The users enters employee new information

The user requests data to update employee file.

The data is added to employee file.

The user presses save and exit out of update employee.

 

           


Event Trace:

 

Generate Schedule Report

 

Scenario 1:

 

The users request to view report.

The system displays types of reports available.

The user select generate schedule report to view all appointment and available times.

The user enters a specified range of data to generate.

The user request start to begin generates report.

The system returns schedule report that meet the range that specific by the user.

The user views the documents that meet the selection criteria.

The user print generated schedule report.

 

           


Event Trace:

           

 

Update Product

 

Scenario 1:

 

The user request to search for a product.

The system prompt for type of products.

The user enter product type, it could be merchandise or service.

The user enter product name.

The user request search to start.

The system retrieve user information to update.

The system return product that meet the user request.

The user selects a product.

The user views the product information.

The user updates any new information on that particular product.

The user save and exit out of product update.

The system saved the update of product information.

            Event Trace:

 

Add Product

 

Scenario 1:

 

The user requests to add Product.

The system prompts for user to enter type product such as Service or Merchandise.

The user request add new product.

The user adds new product information.

The system adds new information to product profile.

The user click saves new product information.

The user exit out of add product.

                  The system store the add information production.

 

           


Event Trace:

           

 

 


State Transition Diagram

 


Appendix I (group members’ contributions)

 

Background/Requirements Specification – Damon Green

ER Model – Andy Hund

Object Model – Damon Green

Data Dictionary – Damon Green

Use Case Diagram – Ka Lor

Use Cases – Divided among group member in proposal.

 

Use Case Scenarios, Event Traces, User Views, and State Transition Diagrams were all divided throughout the group according to use cases as follows.

 

Andy Hund

Add/Update Pet

Add/Update Clients

Damon Green

Login

Process Payment

Schedule Appointment

Fahd Khan

Cancel Appointment

Update Invoice

Email Client’s Reminder Report

Ka Lor

Add/ Update Employee

Generate Schedule Report

Add/Update Products

Sharon Springorum

Peak Appointment Time Report

Unpaid Invoice Report

Add/Update Available Appointments