Auto Parts Management Application Software

Create an application that will allow auto parts dealers to keep track of their inventory system.

Minimum requirements for the solution include:

· Add/delete/edit auto parts based on the type, year, car model, and price

· Add/delete/edit customer details

· Add/delete/edit employee details with different roles defined (for security purposes. eg only certain employees can change inventory details). Employee security levels should be assignable to give them access to only change certain parts of the system; the three parts being auto parts details, customer details, and employee details.

· Search screen, where an employee can search by following the filters: type, year, car model, price

· Transaction screen which captures customer details, parts being sold, and the price. Once the transaction is complete

o Payment information must be captured into a table

o Update the inventory details

· Able to view reports on sales/inventory for a date range

Optional features:

· Transaction reversal

· When a customer returns the parts, the transaction should be reversed (i.e: sales details, and inventory needs to be reversed, but with a new transaction that captures this, so that a record of the returned parts is shown in the system)

These are the basic features of the system, and the contestants are free to come up with more features, and the marks will be based on the (creativity, complexity, user friendliness, and on the coding style)

Contestants can use any language of their choice, but the recommended tools are:

· VB (recommended because of the nature of the application)

· VC++

· Java

· A database such as MySQL or MSAccess