CSE1IS Information Systems
Assignment 2 Part B

Introduction

Noel’s CarMart, a used car business, decides to implement a customer relationship information system to keep track of Prospects. Prospects are people who enter the car yard and are interested in purchasing particular vehicles. Each Prospect is assigned to one Salesperson to provide a more consistent purchasing experience. A Salesperson is required to know each Prospect by name as soon as possible and be aware of the Vehicles a Prospect has shown interest in.

After a number of interviews with Noel and the salespeople you come up with the following brief description of the data storage requirements. The following data needs to be stored:

Salespeople

A Salesperson’s code (two characters representing first name and surname eg. John Smith = JS), name and phone extension.

Vehicles

A Vehicle's registration number, make, model, year, color, odometer reading, date of purchase, cost price, sale price and sold status. Sold status is either "Sold" or "For Sale"

Prospects

A Prospect’s name and phone number.

Contacts

An interaction between a Propsect and a Salesperson about a particular Vehicle is known as a Contact. Whilst a history of Contacts between a Salesperson and a Prospect about a particular Vehicle is not necessary it is important to know when intial contact was made, the most recent contact date and the contact status. Each time a Contact is made the most recent contact date should be updated. The contact status should be "Pending" if there is current interest in the Vehicle, "Sale Completed", or "Contact Discontinued" if a Prospect has clearly indicated no further interest in the Vehicle or contact has not been made for 2 months or the Vehicle has been sold. It should also be possible for a Salesperson to accumulate notes about a Prospect's interest in a particular Vehicle.

NOTE: A Prospect may be interested in more than one Vehicle at a time.

Two reports are required:

1. Prospects to Contact Report - this report is to be printed and should list all of the Salespeople in alphabetical order (beginning a new page for each Salesperson) who have a "Pending" Contact where contact has not been made for more than 2 weeks and the Vehicle is still "For Sale". A Salesperson may have more than one Prospect to contact about multiple Vehicles, in which case the Propects should be in alphabetical order and the Vehicles in registration number order. For each "Prospect to Contact" the Prospect's name and phone number and the Vehicle's registration number, make and model should be diplayed as well as the last contact date.
2. Contact Notes Report - this report should appear on the monitor only and is for a single Prospect and should be able to be displayed when a Prospect phones or enters the car yard. A Salesperson should be able to enter a Prospect's name and any vehicle the Prospect currently has an interest in should be displayed. For each vehicle the last contact date, vehicle registration number, make, model, color and sold status should be displayed along with the Notes describing the Contacts to date.

Specific requirements

1. An Entity Relationship diagram for the system (4 marks).
2. A design for the the system's Main Menu (2 marks).
3. A screen for recording a Vehicle's details. (3 marks).
4. Designs for the 2 reports (6 marks).

Submission requirements:

• The assignment should be firmly bound in an A4 size folder. Do NOT submit assignments in plastic sheet protectors.
• Title page:
  • Subject name
  • Assignment title
  • Student name
  • Student ID number
  • a signed Statement of Authorship
• Table of contents
• ER diagram
• Menu design
• Contact screen design
• Report designs

This page last updated on 19/08/08 by Chris Cope, La Trobe University, Bendigo