Literature Review

LiteratureReview

Literature review

Each business needs an intuitive database system that will be freefrom errors and make the operations more efficient. In fact, adatabase that is poorly designed will interfere with the day to dayoperations and waste more time and costs because of the endlesserrors. The interface and the controls of the system are some of theelements that determine the efficiency of a database system that isproperly designed. It will ensure that the data is manipulatedproperly to ensure that the business achieves everything considered.The database system should have the ability to store, retrieve aswell as update data. As long as these three functions are efficient,the chances of the system having human errors will be low.Collaborative software is also critical in increasing the efficiencyof the interface and the management of the data. For instance, onecan use a wide range of software such as the ones with the ERPsystems or even the basic ones that are common in IT management. Inthe case, of a small business, the Microsoft SharePoint often helpsin managing the data and ensuring that the management has an easytime dealing with it.

A suitable database system should consider that the users havevarying experience. For instance, it should be easy for the learnersto manage the database and ensure that an expert can still find a wayto manipulate it without any difficulties. Pickett (2006) revealsthat a database should have various mandatory characteristics thatwill enhance its performance in the long-run. He insists that thedatabase should be able to support object identity, operate simplertasks, offer an easy way of querying data and ensure the mutualcoexistence of the users as they work on the various interfacessimultaneously. In fact, he supports that and he reveals thatMicrosoft Access meets all the mandatory requirements, and that makesit perfect for such functions.

Storey &amp Goldstein (1993) insists on the need to consider theinterests of the managers, the end users as well as the customers. Inparticular, the managers are the one that approves the costs setaside for the entire project hence, including them in thedecision-making process is a better idea. On the other hand, the endusers are the ones that will operate the database, and they willexpect a certain performance rate. They might even offer insightsthat will influence the desired functionality and ensure that thedatabase meets the required outcomes. Lastly, even the customers areanother important group since they will have expectations on thereporting abilities of the database too. All in all, this group is animportant part of the success of the database since it ensuring itsefficiency as well.

Mason (1985) illustrates how the functionality determines a betterdatabase program that a business should use. Besides that, he evenconsiders various factors such as the ease of use and ease inlearning how to operate the program. The performance and flexibilityalso stand out as the key elements that an efficiency system databaseshould adopt. How the software will be used in generating data isalso another important part that will push the users into managingdata. There is the need to consider the spreadsheet programs thatwill be able to undertake the arithmetic calculations, the overallappearance of the spreadsheets as well as the cost of the entireprogram. The compatibility of the spreadsheet programs with theoperating system also facilitates the success of the database system.Hence, the selection criterion has to consider such factors beforestarting the operation.

Moran et al., (2013) reveals how the British Society ofUrogynaecology (BSUG) was able to implement and operate theirdatabase system. For about five years, they had tried severalversions of the databases and even included Microsoft Access. Later,the management decided to create the BSUG.NET that ended up being asuccess since it was a first online urogynaecology database that wascreated to help the organization. The process faced a few challengesat first, but, the ability to contact some of the skilledprofessionals have been able to correct some of the errors and madeit more consistent. It has been able to meet the performance outcomesof the organizations and it had prioritized the efficiency as well.However, such an approach might be costly and needs an organizationthat will be able to raise a lot of funds without any struggle.Instead, this project lacks enough funds to initiate such a databasesystem. In fact, Tenopir (1983) insists that an organization might beable to consider the costs before initiating the project. Hence, theMicrosoft Access will be much applicable since it is way cheaper andmeets the same demands as before. It also has all the requiredfeatures needed in making the project a success. The process ofentering the data and ensuring that they are well-arranged are not ahuge problem since Microsoft Access has the abilities to undertakemultiple tasks simultaneously.

Wise (1999) reveals that including the spreadsheets as well asstatistical programs in the database system is a perfect way ofhandling a dietary program. More specifically, the concepts that heprovides might be quite effective in this project since it willreveal all the essential details that will enhance its performance.Wise (1999) insists that the database systems often help in providinginstant answers to any complex question related to the dietaryprogram. He even reveals some of the commercial packages such as theDiet5 for Windows, Access, and Minitab as some of the most recentones. The spreadsheets will clearly make the work a bit easier andenable the project team to perform as expected and reduce any humanerrors that the program might present. It even gives the detailedsteps that one might follow in filling the databases to ensure theaccuracy. All in all, the article is quite credible, and it addressesmultiple elements that the project will cover. Hence, the projectwill borrow most of the ideas on the way to arrange the databases toensure the ease of updating and retrieving data as well.

Schneider et al., (2005) reveals the perfect way of creating auser-friendly database that will support the operations that abusiness undertakes. The article gives a detailed plan that offers amaster plan that will ensure every user has a chance to update andretrieve data from the system efficiently. It reveals the potentialerror that arises from entering data where one has to use endlesskeystrokes at a time. However, the automatic tabbing provides a wayof avoiding all those human errors and ensuring that the databasecaptures the data accurately. The article insists on the need tounderstand the bigger picture of the way that Access works in variousorganizations. In detail, the bigger picture refers to the generalpurpose of the database systems. From that point, dealing with thesmaller roles such as entering data and arranging them appropriatelywill not be a problem. Other processes such as creating tables,setting up a form, modifying it and other activities are allexplained in the article. The concepts in the article offer theinsight needed in making the data more precise and the entire systemmore presentable as well.

Horgan, R. (2001) reveals that the proper database systems are quitecritical in ensuring that the team works perfectly to achieve therequired outcomes. In this case, the teamwork is essential to thesuccess of the project and the way that the data is entered, updatedand retrieved. A database system that is full of human errors is morelikely to create conflicts among the team members since they willkeep blaming each other. More likely any error will be traced back tothe origin, and that might reduce the morale and lead to the teamfeeling like some of them are not that serious. However, theMicrosoft possesses a number of features that are influential inguiding the team in finishing each of the required tasks. In theprocess, the entire process ends up being friendlier. Moreimportantly, a perfect selection criterion is quite appropriate inensuring that the database system works efficiently and considers theneeds of the stakeholders as well.

References

Horgan, R. (2001). Standards database fosters teamsuccess.(Technology). Journal of Property Management, 66(6),66-68.

Mason, Robert M. (1985) Choosing Spreadsheet and Database ManagementSoftware. Library Journal. Vol. 110 Issue 17.

Moran, P., Foon, R., &amp Assassa, P. (2013). The BSUG nationaldatabase: concept, design, implementation and beyond. TheObstetrician &amp Gynaecologist, 15(2), 120-127.

Pickett, T. (2006). Choose Your Weapon (Selecting Estimating Toolsand Databases). AACE International Transactions, ES111.

Schneider, J. K., Schneider, J. F., &amp Lorenz, R. A. (2005).Creating user-friendly databases with Microsoft Access: Data entrycan be tedious and is fraught with potential for errors that affectstudy findings. Researchers can minimise entry errors and streamlinedata entry by using some of the popular software packages on themarket. Joanne Kraenzle Schneider and colleagues describe one way tocreate a user-friendly database that minimises entry errors by usingMicrosoft (MS) Access. Nurse researcher, 13(1), 57-75.

Storey, V. C., &amp Goldstein, R. C. (1993). Knowledge-basedapproaches to database design. MIS Quarterly, 25-46.

Tenopir, C. (1983). In-House Databases. 2. Evaluating and ChoosingSoftware. Library Journal, 108(9), 885-888.

Wise, A. (1999). Appropriate uses for spreadsheets, databases andstatistical software for the analysis of dietary data. Internationaljournal of food sciences and nutrition, 50(2), 111-115.