Benefits of a Database and Information-Gathering Techniques
July 27, 2013
I am being interviewed by ACME Global Consulting services as a potential new employee to its growing work force of world-class systems analysts and requirements engineering group. Through a tip, I found out that they will be asking several questions relating to planning for a new database for one of their national restaurant chains. I found out that one of the executives at the restaurant chain only believes in using Microsoft Excel for running reports. For this assignment I will be focusing on 3 main topics. First, I will describe the benefits of using a database management system and how it supports this restaurant chain. Second, I will propose how I would address the issues with flat file systems, such as Excel and Text files, for storing data. Lastly, I will list and describe three tools, techniques, or methodologies for eliciting and documenting requirements related to the development of a new database. So, as you see, you have your plenty of things to get ready for. A Database Management System (DBMS) is the software system that allows users to define, create and maintain a database and provides controlled access to the data provided by your database administrator(s). DBMS is an intermediate layer between programs and the data. Programs access the DBMS, which then accesses the data. There are different types of DBMS ranging from small systems that run on personal computers, corporation window servers, large mainframes, etc. Let’s look at some of the benefits from have a DBMS. 1) Controlling Redundancy: In file system, each application has its own private files, which cannot be shared between multiple applications. This can often lead to considerable redundancy in the stored data, which results in wastage of storage space. By having centralized database most of this can be avoided. 2) Integrity can be enforced: Integrity of data means...