Computer Component Tracking System
Essay Preview: Computer Component Tracking System
Report this essay
Computer Component Tracking System
Table of Contents
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 partners 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