CPSY $200$ FINAL PROJECT

This is an individual assignment.

Scenario

Village Rentals has been a family run business for several decades. The patriarch, Arnold Svenson started the business in the early $1950$s servicing what was then a mostly rural township.

Ever thrifty, the Svenson$$s were quite careful on how money was spent. The business was run using hand$-$written ledgers and index cards for decades. The first computer and printer were not installed and operated until the early $1990$s$.$

Times have changed considerably, and the once rural township is now quite busy with new developments in the surrounding area. Village Rentals has acquired a lot more equipment to service the township and running the business from spreadsheets is no longer feasible. Your task is to design a system that use a relational database to track equipment, customers, and rentals.

The system must do the following:

Manage the equipment inventory.

This includes adding new equipment or removing equipment from inventory. Equipment that has been used, but still in working order can be removed from inventory and sold. Equipment that is seriously damaged or worn is removed from inventory. $($It$$s never thrown away of course. $$You never know when you need parts$,$ said the elder Svenson$)$

Manage Customer Information.

Enter the information for a new customer or update the information of a current customer. Note: Some customers have been banned from renting equipment.

Equipment Rental.

Each rental has a unique number, the customer, the equipment $($there can be more than one item$),$ the rental date and return date.

System Management.

Given the rapid development within the township, they will be adding new categories of equipment.$\backslash$

Generate Reports.

The system will allow for a selection of reports:

Sales by date.

Sales by customer.

List items by category.

Other customizable reports.

Current system information

The current information has paper forms and a series of spreadsheets with information. Your research has found the following information:

Category List

Each category has a number and a description:

$10$ Power tools

$20$ Yard equipment

$30$ Compressors

$40$ Generators

$50$ Air tools

Rental Equipment

Each piece of equipment has the following information:

Equipment id number

Category

Name

Description

Daily Rental Cost

Customer Information

Each customer has the following information listed:

Customer id

Last name

First name

Contact phone

E$-$mail

You noticed some handwritten notes on a few records. $$Give $10\%$ discount$$ and $$NEVER RENT TO THIS $\_\_\_\_\_\_\_\_$R AGAIN!!!$$

Rental Information

Each rental document had this information:

Rental id

Current Date

Customer id

Customer Last name

For each item:

Equipment Id number

Rental Date

Return Date

Cost of rental

Total final cost of rental

Instructions

Your goal is to develop a report detailing the design of a system to meet your client$$s needs. Your system will use Object Oriented programming concepts.

Your project must use Software Ideas Modeler $($SIM$)$ as the CASE tool for this project.

There will be a $30\%$ reduction in marks if you do not submit an integrated $($SIM$)$ project file.

You are provided with sample data listed in data$-$samples.xlsx $.$

Part A: Analysis and requirements gathering. $(15$ Marks$)$

Using SIM, create a project and complete the following diagrams:

$1.$ Use Case Diagram and descriptions. Create a use case diagram and write a brief description of each use case.

$2.$ Analysis Level Class Diagram. Note: this does not require UI$/$UX classes

$3.$ A conceptual Entity Relationship Diagram $($ERD$).$ Include Primary and foreign keys.