System Proposal

System Proposal

After analyzing the process of the CBPA Equipment Tracking System, Cheney Int'l Team has provided issues and needs that should be taken into consideration.

Issues

Managing Inventory

1.Currently, CBPA does not track any information about any un-tagged equipment.

Distribution of Inventory

1.CBPA it does not track equipment within its own departments.

2.CBPA does not generate reports, so it will not acknowledge the distribution of an equipment

3.CBPA has trouble finding missing equipment.

4.The department of CBPA does not record or track any history of the distribution of their equipment. This restricts us to find missing equipments or the cause of faulty equipments.

Configuration of Inventory

1.CBPA lacks in keeping detailed records and original configurations of its equipment.

2.CBPA lacks the knowledge in the values of the installation and maintenance cost.

3.CBPA lacks the maintenance and installation history on equipments. This does not allow us to know when, what, and how the equipments are maintained.

Solutions to Issues

Cheney Int'l has provided solutions and opportunities concerning the issues mentioned previously.

Managing Inventory

1.Storing the information of the un-tagged equipment to relational database allows CBPA to track information efficiently. The relational database has functions to generate unique numbers. CBPA will be able to identify un-tagged equipment by relating the unique numbers to specific equipment. Access or SQL server systems will manage and organize the specific actions in a relational database.

Distribution of Inventory

1.Being able to develop detailed information for the CBPA departments to track each piece of equipment and its room location from the relational database. This will allow us to track the equipments distribution within the CBPA departments. Access or SQL server systems will manage, categorize and generate reports from the information given in a relational database.

2.Storing information to a relational database allows us to generate reports and access the information in various views by using the query function. Access and SQL server will allow different techniques in searching information through a query function.

3.Storing useful information to a relational database allows CBPA to find possible missing equipment using the querying function. e.g. (If an equipment has not been distributed for a couple of years, then it can be suggested that the equipment is missing.) Access or SQL server systems will manage and locate missing items in a relational database.

4.In our relational database you will be able to store information according to their unique key. This will allow the process to store the history of the equipment in a relational table. Access or SQL server systems will manage, organize and allow you to view the history distribution of the specific equipment in a relational database.

Configuration of Inventory

1.Having categorized columns in a relational database allows CBPA to have detailed information of a specific equipment. Access and SQL server will allow different techniques in searching information through a query function.

2.Including a price column in a relation database, CBPA will be able to calculate the cost of maintenance and the values of installation. Access or SQL server systems will manage and organize the specific actions in a relational database.

3.By storing information to a relational database with a correct unique key, a table in the relational database is able to store the history of the maintenance. Access or SQL server systems will manage, organize and allow you to view the history of the maintenance in specific equipment in a relational database.

Course of Actions

Cheney Int'l Team has provided solutions and alternatives for the Equipment Tracking System that will manage the system process. Included are the pros and cons in the proposed options which will help determine which database is the best fit for the CBPA Equipment Tracking System.

Database

Access

Pros

Cheap

User - Friendly

Access is very popular and often already installed at your location

Easy Modification

Cons

Capacity does not handle large data and limits expansion in the future

SQL Server

Pros

Cheaper than Oracle

More user - friendly than Oracle

Capable of Managing Large Data

Cons

More difficult than access

Generates excessive CPU Memory and hard disk

Requires Expert Users

Oracle

Pros

Reliable

Popular with business

Capable of Managing