CPSY200 - Efficient Equipment Management Village Rentals Database System Assignment

Assignment Task

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 Svensons 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 is 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.

• 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

Part

A: Analysis and requirements gathering

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.

4. Two sequence diagrams related to specific use cases listed in the use case diagram.

5. Two activity diagrams describing two processes in your system.

Create a word document titled ‘CPSY200 Final Project’ with this structure:

B: Design and Prototyping

Using the feedback you received in Part A, make the appropriate corrections to your project, including the SIM project diagrams.

Complete the following design elements for your project.

Create prototype user interfaces for this system. Create the necessary interfaces for each use case listed. You can use Figma or any other suitable design software.

Create these new diagrams in you SIM project:

1. Design level class diagram . This will include the UI classes and the database connection class (or classes) that will read and write to the database. Note: The UI classes do not require a list of each attribute. E.g. attribute for a textbox or radio button. However, they will list the references to other classes and event methods.

2. Create new sequence diagrams that incorporate the UI and database connection class(es). Note: Do not delete your previous (revised) sequence diagrams.

3. Create a package diagram for your system.

Revise your project document as follows:

• Export your new diagrams and add them to your document after your original diagrams. One diagram per page.
• Include screenshots of your UI design after the package diagram.
• Submit your revised document, SIM project file under ‘assignments/finalproject/design’

Prototyping

Using Java or other suitable object-oriented language create a prototype with a basic GUI that does the following:

• The program can add or delete equipment.
• The program can add a new client.
• The program can display all the equipment.
• The program can display all clients.

This CPSY200 – Management has been solved by our PHD Experts at My Uni Paper.