Question

You are a database designer and data analyst working for the hypothetical employer, Park University. The University over the last few years has provided faculty and staff needed technology to support various job functions but is having some trouble tracking such technology to ensure the program is cost-effective.   In other words, the University Controls Department is having difficulty locating inventories and associated invoicing information. With the lack of this important information, the University Controls department has a very difficult time locating and tracking released technology which has the intended purpose of being an asset to assigned employees and departments.

The University Controls department has a Technology Asset Management System currently designed and implemented using Microsoft Access; however, the Chief Information Officer (CIO) of Park University needs some ideas of possible reasons the current Technology Asset Management System designed in Microsoft Access is not currently tracking technology assets as intended.

In a memo style response to the Chief Information Officer (CIO), share-based on your knowledge learned about databases using experience and research, some possible and or hypothetical reasons why the existing database, in this case, is not working as intended?

Answer 1

The existing database is not working because of a viable inside control structure for stock incorporates an organization's arrangement of association and all the methodology and moves it makes to:

• Secure its advantages against robbery and waste.
• Guarantee consistency with organization approaches and government law.
• Assess the presentation of all workforce to advance productive activities.
• Guarantee precise and dependable working information and bookkeeping reports.

Ensure Assets

Organizations ensure their advantages by

(1) isolating representative obligations,

(2) doling out explicit obligations to every worker,

(3) turning worker work tasks, and

(4) utilizing mechanical gadgets.

Isolation of representative obligations Segregation of obligations necessitates that somebody other than the worker answerable for defending an advantage must keep up the bookkeeping records for that benefit. Likewise, representatives share obligation regarding related exchanges so one worker's work fills in as a keep an eye on crafted by different representatives.

At the point when an organization isolates the obligations of workers, it limits the likelihood of a representative having the option to take resources and conceal the burglary. For instance, a worker couldn't take stock from an organization and have the robbery go undetected except if another person changes the stock records to cover the deficiency. To change the records, the worker taking the stock should likewise keep up the stock records or be in a plot with the representative who keeps up the stock records.

The task of explicit obligations to every worker When the duty regarding a specific work is appointed to one representative, that diplomat is responsible for explicit errands. Should an issue happen, the organization can rapidly distinguish the mindful worker.

At the point when an organization gives every worker explicit obligations, it can follow lost reports or decide how a specific exchange was recorded. Additionally, the representative liable for a given assignment can give data about that task. Being answerable for explicit obligations gives individuals a feeling of pride and significance that normally makes them need to perform as well as could be expected.

The pivot of worker work tasks Some organizations turn work tasks to dishearten representatives from participating in long haul plans to take from them. Workers understand that if they take from the organization, the following representatives allocated to their positions may find the robbery.

Much of the time, organizations have the arrangement that all workers must take a yearly get-away. This strategy additionally demoralizes burglary because numerous untrustworthy plans breakdown when the worker doesn't take care of the plan every day.

Utilization of mechanical gadgets

Companies utilize a few mechanical gadgets to help secure their advantages. Standardized identifications scanners make it hard for representatives to take stock and change organization reports and records.