...Brian Morgan James.Neiman CIS 111 Benefits of a Database and Information-Gathering Techniques April 28, 2012 Benefits of a Database and Information-Gathering Techniques Database: Database is the collection of data or information, so that it can be easily fetched, managed and update. In database data or information is stored in the forms of tables. Each table in a database has it unique name and table duplication is not allowed. Example of database: Oracle 10g, MySQL, SQL Server, IBM DB2 etc. DBMS terms refer to the database management system. A database management system (DBMS) is a collection of software application package with some computer programs that are used to store, create, fetch, modify and extract the information from the database. Each DBMS system has some set of rules and pre-defined paradigm on which each database is working. There are many different types of DBMSs, ranging from small systems that run on personal computers to huge systems that run on mainframes or Solaris servers. Some of the example of DBMS is 1.> Air lines flight management system. 2.> Employee’s payroll management system for an organization. 3.> Inventory management system for warehouse operations. 4.> Student management system for Schools and Colleges. Advantages of DBMS 1.> It reduces the data redundancy (duplicate data in the database). 2.> Scalable: DBMS systems are highly scalable i.e. these systems can be scaled to store more data as required in...
Words: 777 - Pages: 4
...system. This is with an idea of suggesting the best methods of information management through the use of data warehouse concepts for the proposed Greenville School Hostel Management System. The result of literature review gives us information with regard to the research done on the topic by others researchers. Result of this review will be the gaps that are found in the existing works and the good features that can be suggested for the proposed system. A data warehouse is projected in a way that data can be stored and accessed and is not restricted only to tables and relational lines. (Fink, 1998) As the data warehouse is separated from operational databases, user’s queries do not cause any impact in these systems. Data warehouse is protected from any non-authorized alteration or loss of data. Data warehouse contemplates the base and the resources needed for a Decision Support System (DSS), supplying historic and integrated data. These data are for top managers, decision makers, and partners, donors – who need brief, summarized and integrated information – and for low-level managers, for whom detailed data helps to observe some tactical aspects of the organization. In this way, data warehouse provides a specialized. For a centralized database oracle will be used for storing details of data being brought from different hostel location of the organization and saved into single database using oracle database management system. (BI / DW Insider, 2011) 2.2 BACKGROUND The...
Words: 2337 - Pages: 10
...are performed in a strict sequence. One phase must be completed before the next activity can be carried out and that no phase is to be repeated. However, the linear systems development life cycle is subjected to a number of critics which are the real information systems project rarely follow such a simple sequential cycle. Phases may be overlapped and activities may have to be repeated. Alterations are needed as inadequacies in the analysis phase mat become evident only during the design, construction or implementation phase. A great amount of time may have elapsed between the preliminary investigation and the final implementation. Also, the new technology existence may not be possible to incorporate new technology without redoing the analysis and design work already completed. System planning Information system strategic planning is a set of long-term goals that describe the information architecture and major information systems initiatives needed to achieve goals of the organization. The steering committee is set up to represents the top management and all functional areas within the organization and responsible for overall planning and control of the system development effort of the organization. Prior to developing Information System, long term and short term planning must be...
Words: 6561 - Pages: 27
...Running head: RIORDAN MANUFACTURING Riordan Manufacturing BSA375 Ed Odjaghian July 16, 2012 Abstract Riordan Manufacturing Chief Operating Officer, Hugh McCauley, has hired Butner Consulting to integrate all existing Human Resource tools into a single integrated application for all Riordan Manufacturing locations. Riordan Manufacturing wants to take advantage of a more sophisticated, state-of-the art, information systems technology in their Human Resources department ("Service Request Riordan Manufacturing", 2011). Butner Consulting will be responsible for defining the business requirements for the development of the HR system to support the objective of this request. Butner consulting will create a detailed system design and project implementation plan required to complete this project. This project is expected to be completed within six months so the new system can be utilized in the second quarter of next year ("Service Request Riordan Manufacturing", 2011). Stakeholders During this System Development Life Cycle the first phase is “analysis.” Analysis involves detailing the business requirements for the project and what is expected. This stage places a great deal of emphasis upon stakeholder involvement in drafting, reviewing and approving the requirements. These requirements are prioritized in discussion amongst stakeholders so that critical success factors can be defined. Stakeholder involvement is essential to work towards success and satisfactory...
Words: 3201 - Pages: 13
...Manufacturing’s Human resources department to unite the current hosts of HR tools into one application by describing what key stakeholders in Riordan Manufacturing requirements would be gathered from, describe the information-gathering techniques, and systems analysis tools used to evaluate the project, identify factors that will guarantee successful gathering of information required for the project, explain what the scope of the project is and why it is important, lastly, describe the areas of project feasibility that are examined in the analysis phase of the SCLC. Stakeholders in Riordan Manufacturing Riordan Manufacturing is in need of a system that will place all HR components into one secure centralized location. To resolve all inefficiencies within the current system, it is essential that information is gathered as much as possible to identify already known and potential issues that need to be corrected. Reviewing current policies and procedure documents for the existing system will give an understating of how the present day system is functioning, in addition will be helpful in identifying key individuals that need to be interviewed in gathering additional information from. “Interviewing is one of the primary ways analysts gather information about an information systems project” (Valacich & Hoffer, 2012). Interviewing key users would a better view of the needs required for the new system. The questions asked during the interview will be used to obtain...
Words: 2280 - Pages: 10
...Chapter 04The Research Process CHAPTER LEARNING OBJECTIVES AFTER READING THIS CHAPTER, STUDENTS SHOULD UNDERSTAND… 1. Research is decision and dilemma centered. 2. The clarified research question is the result of careful exploration and analysis, and sets the direction for the research project. 3. How budgeting and value assessments influence the process for proposing research and, ultimately, research design. 4. What is included in research design, data collection, data analysis, and reporting. 5. Research process problems to solve. CHAPTER Lecture Notes THE RESEARCH PROCESS Stage 1: Clarifying the Research Question • The management-research question hierarchy process of sequential question formulation leads a manager or researcher from management dilemma to investigative questions. • The process begins with the management dilemma—the problem or opportunity that requires a business decision. • The management dilemma is usually a symptom of an actual problem, such as: □ Rising costs. □ The discovery of an expensive chemical compound that would increase the efficacy of a drug. □ Increasing tenant move-outs from an apartment complex. □ Declining sales. □ A larger number of product defects during the manufacture of an automobile. □ An increasing number of letters and phone complaints about postpurchase service • The management dilemma can also be triggered...
Words: 2274 - Pages: 10
...CHAPTER 3 METHOD OF GATHERING DATA Find out system requirements and define project scope or boundary of project is important to anticipate the time of completion. By a clearly defined scope, specified time will be assigning to develop each module in the application. From here can conclude that, virtual tour on hotel room needing more time in completion. By well-organized task and duration, the application will develop on time. PARADIGM Waterfall paradigm is important to note a large successful of projects development. Without the structure and organization provided a waterfall paradigm method, development projects would be at severe risk of missing deadlines, escalating budgets and a low quality system. As a methodology, the water fall paradigm provides the structure method, controls and checklist needed to ensure successful development figure below show the phases in software process waterfall paradigm. Preliminary investigation Requirement analysis Design Testing Construction Implementation maintenance Paradigm: Waterfall Model Waterfall paradigm prescribes stages and activities performed in each stage are describe as fallows: a) Preliminary investigation The major requirement for online hotel reservation system is to provide back office forContent management, reservation management and housekeeping management. The online hotel reservation hotel system also expected to provide a better preview of the hotel rooms. These features are in order to...
Words: 1291 - Pages: 6
...Benefits of a Database and Information-Gathering Techniques CIS111 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...
Words: 941 - Pages: 4
...Riordan Manufacturing, Inc. SR-rm-220 Michael S Black BSA 375 August 6, 2012 John Dunn Riordan Manufacturing, Inc. SR-rm-220 Introduction and Brief History “Riordan Manufacturing is a global plastics manufacturer employing 550 people with projected annual earnings of $46 million. The company is wholly owned by Riordan Industries, a Fortune 1000 enterprise with revenues in excess of $1 billion. Its products include plastic beverage containers produced at its plant in Albany, Georgia, custom plastic parts produced at its plant in Pontiac, Michigan, and plastic fan parts produced at its facilities in Hangzhou, China. The company's research and development is done at the corporate headquarters in San Jose. Riordan's major customers are automotive parts manufacturers, aircraft manufacturers, the Department of Defense, beverage makers and bottlers, and appliance manufacturers. The company was founded by Dr. Riordan, a professor of chemistry, who had obtained several patents relative to processing polymers into high tensile strength plastic substrates. Sensing the commercial applications for his patents, Dr. Riordan started Riordan Plastics, Inc. in 1991. Initially, the company's focus was on research and development and the licensing of its existing patents, but in 1992 Dr. Riordan obtained venture capital which he used to purchase a fan manufacturing plant in Pontiac, MI. At that time, the company's name was changed to "Riordan Manufacturing, Inc." In 1993, the company...
Words: 3367 - Pages: 14
...CONTENTS Chapter I: System Background A. University Background/Company Background B. Organization Directory C. Objective of the Study D. Theoretical Framework E. Conceptual Framework F. Significance of the Study G. Scope of the Project H. Delimitation of the Study Chapter II: System Plan A. Problem Description 1. Problem Description 2. Anticipated Business Benefits 3. System Capabilities B. Project Schedule 1. Work Breakdown Structure 2. Project Evaluation and Review Techniques C. Project Feasibility 1. Economic Feasibility 2. Technological Feasibility 3. Operational Feasibility 4. Cultural/Political/Organizational Feasibility Chapter III: System Analysis A. Information Gathering Tools and Techniques 1. Questionnaire 2. Interview Guide 3. System Documentation B. Hardware Requirement 1. Event Table 2. Class Diagram 3. Use Case Diagram 4. Use Case Description Chapter IV: System Design A. System Design Model 1. Screen Layout 2. DFD (Data Flow Diagram) 3. ERD (Entity Relationship Diagram) 4. Database Design 5. Table Relationship Diagram 6. Data Dictionary Chapter V: Conclusion and Recommendation A. Conclusion B. Recommendation C. Curriculum Vital CHAPTER I University Background HISTORY OF SHEPHERD GRACE SCHOOL SGS-Shepherd’s Grace School, Inc. is a Catholic School and is open to all religion. It respects personal preferences and values...
Words: 3231 - Pages: 13
...Running Head: Riordan Manufacturing SR-rm-004 Riordan Manufacturing Human Resources Information System By: Adrian O. University of Phoenix February 22, 2010 Abstract To identify, analyze and propose Riordan Manufacturing Human Resources (HR) Systems. In order for Riordan Manufacturing to be competitive in today’s market, it is necessary for the system to be updated. Utilizing a system development life-cycle (SDLC) methodology to analyze and create a project plan to update Riordan’s HR system. Following SDLCs structure and its categorizations, the five phases will be covered in this paper and they are the following: project planning, analysis, design, implementation, and support (Burd, et al, 2004). In addition, this paper will also tackle the different types of information gathering that is best for the success of the project. According to Burd, S.D, et al (Systems Analysis and Design in a Changing World, 2004), there are several methods of information gathering and most widely used, and they are the following: Review existing reports, forms, and procedure descriptions; Conduct interviews and discussions with users; Observe and document business processes; Build prototypes; Distribute and collect questionnaires; Conduct joint application development (JAD) sessions; Research vendor solutions. Company Background Founded by a professor of Chemistry in the year 1991, Dr. Riordan’s company initially a research and development and licensing of its existing patents, obtained...
Words: 3386 - Pages: 14
...current system has become outdated and inefficient. Since the original system was put in place to integrate the San Jose office and the office in Pontiac, Michigan the company has added two more entities to the business. Riordan now has offices in Albany, Georgia and a manufacturing plant in China. As with most of their systems, the HR system is currently functioning as several different systems operating independently of one another. This creates issues with format and conversion of documents and information between offices, unnecessarily cutting down on employee productivity. The first step in the process of updating and integrating Riordan Manufacturing’s human resources department will begin with gathering of information. During this process there will be several techniques used to allow this maximum amount of input from the company and its employees to discover the downfalls of the current system and in detail what is expected within the company requirements of the new system. Information will be gathered by the use of interviews with stakeholders and employees as well as brainstorming, company document analysis, site observation at the corporate office in San Jose,...
Words: 3336 - Pages: 14
...properly maintain the employee information and other human resource information a service request has been submitted to consolidate all of the various human resource tools into one single application that integrates all of the tools together. This will allow the company to streamline human resource functions across the company. Key Stakeholders There are a number of stakeholders within the company that will need to provide input into the scope of this project. By gathering this input from the necessary personnel within the company it will ensure that the project requirements are complete as well as comprehensive so that all areas of impact are included. The first stakeholder that will be engaged is the Chief Operating Officer Hugh McCauley. He is the one that requested this project take place and he is over many different department heads within the company including Sales and Marketing, Legal, Operations, and Information Officers. Another key stakeholder will be the Director of Human Resources Yvonne McMillan. She oversees all of the department heads for all aspects of human resources. As we reach out to her the expectation is that she will assign a number of her managers to provide input from the various departments like payroll, benefits, employee relations, and training and development. Information Gathering Techniques There are many different techniques that can be used to gather information and requirements. There are techniques that can be considered more traditional...
Words: 3128 - Pages: 13
...produces plastic beverage containers, a plant in Pontiac, MI that produces custom plastic parts, and a plastic fan parts facility in Hangzhou, China. Riordan Manufacturing’s corporate office is located in San Jose, CA along with the corporations Research and Development Department. Mr. Hugh McCauley, the current COO of Riordan Manufacturing has submitted a Service Request (SR-rm-022) to Smith Services Consulting Inc. requesting to combine the existing Human Resource (HR) tools into a single application using today's existing tools in the HR system. This request will affect all plant locations. Riordan Manufacturing is looking to benefit from a more state-of-the-art information systems in its HR department. The service request will include information gathering about what the new system should include, the current system needs to be analyzed, the information gathered needs to be verified, and the scope of the work needs to be determined. A. What key stakeholders in Riordan Manufacturing would you gather requirements from? To gather all the proper requirements for the new HR system all the key stakeholders within the Riordan Manufacturing must be asked. The key stakeholders are the upper management of Riordan they will be able to provide the requirements of the new system, the budget and all the due dates. 1. President and CEO Dr. Michael Riordan is the highest stakeholder in Riordan Manufacturing, he has the most to gain from this service request. 2. COO Hugh McCauley has...
Words: 3115 - Pages: 13
...more sophisticated, state-of-the art, information systems technology in our Human Resources department.” In this paper I will address the key factors to analyze the HR system tools such as; Riordan key stakeholders, Joint Application Development, Use Cases, Process Models, Data Models, successful information gathering, and project scope. Riordan HRIS According to the Apollo Group Inc. simulation (2011), on the employee site under HRIS, the company’s HRIS was developed in 1992 and is a part of the financial systems package. It keeps track of the employees’ personal information, pay rate, personal exemptions for tax purposes, hire rate, seniority date, organizational information, and vacation hours. Changes to this information are submitted via special forms by the employee’s manager and entered into the system by the payroll clerk. Training and development records are kept in an Excel worksheet by a training and development specialist. Recruiters maintain applicant information for open positions, résumés are filed in a central storage area, and an Excel spreadsheet is used to track the status of applicants. A third-party provider manages the worker’s compensation records. All employee files are kept by individual managers, and there is no central storage. The compensation manager keeps an Excel spreadsheet with the results of job analyses, salary surveys, and individual compensation decisions. Employee relations specialists track information...
Words: 1696 - Pages: 7
