Computer Component Tracking System

Computer Component Tracking System

Table of Contents

System Name.......................................................................................................2

Type of System....................................................................................................2

Key System Benefits...........................................................................................2

Interrelations & Interdependencies.................................................................2

Organizational Environment............................................................................2

Stakeholders.......................................................................................................3

Users....................................................................................................................3

Levels of Management Served.........................................................................3

Organizational Culture......................................................................................3

System Functions...............................................................................................4

System Boundaries............................................................................................4

System Interfaces External to the Organization............................................4

System Interfaces Internal to the Organization.............................................5

How System Relates to Organizational Decisions.........................................5

Input Information..............................................................................................5

Process Definition..............................................................................................5

Output Information...........................................................................................6

Data Dictionary.................................................................................................6

Content Level Diagram.....................................................................................8

System Input, Output Forms, and Interfaces................................................10

Testing, Maintenance and Auditing..............................................................14

System Description

System Name

Computer Component Tracking System (CCTS)

Type of System

CCTS is a Management Information System that utilizes Microsoft Access to a database. This database will be integrated into a website.

Key System Benefits

Convert the multiple logbook excel documents with inventories over all locations into one large database that allows all partners the ability to view inventory. Templates will allow information like FedEx tracking accounts, sales, purchasing, and RMA request to all be handled on one piece of software. Website will be constructed. It will include fields that when populated and sent will automatically create information into the database and sends an email notification to all participants. All partner's workstations will have access to database by means of VPN. This will increase the security.

Existing System

The existing system consist of workstations running Window 7 and Microsoft Office. All workstations have internet access and have folders with multiple excel documents, electronic receipts and confirmations. The excel documents are drafted and saved using the name as a reference. The naming scheme is the date and purpose of the document. For an example if a purchase for new parts was conducted the order number and tracking number is put in a excel document that includes all purchases that day. Once the product is received the serial number is associated with an inventory tag which is included into the excel database to keep record of all equipment. When a PC must be built a new excel document is created and all parts needed tags are included. Again the excel document is named by the date and purpose.

Interrelations/Interdependencies with other Systems

The current workstations and software already owned would be sufficient for the new system. Windows 7 and Microsoft Office are the only software needed to run the system. No other hardware or software are needed to purchase. A web designer and system developer are needed to create the system because all partners either have no software developing experience or the lack the time.

System Organizational Environment

The system will be at multiple locations for one small business. The business consist of 3 partners who are located in 3 different areas in the US. To keep cost down they all have similar common items, but big ticketed or rare items are not standardized amongst the locations and need to be made known of availability. With the new database put in partners will have an up to date look at all of the inventory as a whole.

Stakeholders:

* Web Designer

* System Developer

* Partners

Users:

* Partners

* Customers / clients

Levels of Management Served

Level of management would be Upper which includes all partners and the web designer and or the system developer. The lower level will consist of customers who will