A small manufacturing company is expanding by its business by opening multiple branches across the country. Currently all the database is managed by individual employees on Microsoft Excel or sometimes using Microsoft Access. The company is considering updating to a central database management system comprising of several modules for maintaining their manufacturing, inventory, employees and accounting requirements. You are hired to develop a feasibility report as the first phase of the SDLC cycle including the recommendations on economic, operational, technical aspects of the on-going project.

A small manufacturing company is expanding by its business by opening multiple branches across the country. Currently all the database is managed by individual employees on Microsoft Excel or sometimes using Microsoft Access. The company is considering updating to a central database management system comprising of several modules for maintaining their manufacturing, inventory, employees and accounting requirements. You are hired to develop a feasibility report as the first phase of the SDLC cycle including the recommendations on economic, operational, technical aspects of the on-going project.

Principles of Information Systems (MindTap Course List)

13th Edition

ISBN:9781305971776

Author:Ralph Stair, George Reynolds

Publisher:Ralph Stair, George Reynolds

Chapter5: Database Systems And Big Data

Section5.4: Big Data

Problem 2CTQ

See similar textbooks

Similar questions

A small manufacturing company is expanding its operations throughout the country by establishing many facilities. Currently, all databases are managed independently by individual staff members using Microsoft Excel or, on occasion, Microsoft Access. The company is considering upgrading to a centralized database management system comprised of many modules for managing production, inventory, employees, and accounting. You have been hired to do a feasibility study as the first stage of the SDLC cycle, which will contain recommendations on the project's economic, operational, and technological aspects.
You are one of the team members who your project team leader has assigned to involve in the discussion of developing an Automated Teller Machine (ATM) system. Throughout the discussion, you have gathered the following requirements statement for the ATM system from your clients' team members. The IT personnel from your client’s team need to understand the structure of your database and the interaction between the actor(s) or object(s) in the system. Therefore, you have instructed your System Analyst to provide the structural and behavioural modelling of the ATM system based on the requirements statement you gathered, as shown below : AutomatedTellerMachine The software to be designed will control a simulated Automated Teller Machine (ATM) having a magnetic stripe reader for reading an ATM card, a customer console (keyboard and display) for interaction with the customer, a slot for depositing envelopes, a dispenser for cash (in multiples of $20), a printer for printing customer…
Tshepo wants you to examine a UML ERD that an intern developed for another project now that he knows you are an expert with ERDs. The UML ERD and business rules needed to develop it are shown below. Which ten improvements would you make to the ERD to increase its quality and enable it to be deployed effectively in a relational database?You may annotate the diagram and/or explain the modifications in text.
Now that Tshepo knows that you are an expert with ERDs, he wants you to review a UML ERD thatan intern created for another project. Below is the UML ERD and the business rules used to createit. Which 10 changes would you propose should be made to the ERD to improve its quality, sothat it can be successfully implemented in a relational database? You can make annotations on the diagram and/or describe the changes in text.
A tiny manufacturing firm is growing its operations throughout the nation by building various locations. At the moment, all databases are handled by individual staff using Microsoft Excel or, on occasion, Microsoft Access. The firm is contemplating upgrading to a central database management system composed of many modules for the purpose of managing production, inventories, workers, and accounting. You have been engaged to create a feasibility study as the first part of the SDLC cycle, which will include suggestions on the economic, operational, and technical elements of the current project.
Now that Tshepo knows that you are an expert with ERDs, he wants you to review a UML ERD thatan intern created for another project. Below is the UML ERD and the business rules used to createit. Which 10 changes would you propose should be made to the ERD to improve its quality, sothat it can be successfully implemented in a relational database? You can make annotations on the diagram and/or describe the changes in text.Project ACME Grey – Business Rules1. All tables in the database must have surrogate primary keys.2. A product consists of one or more parts. Not all parts captured in the system are part of aproduct yet, and a part can be used in many products.3. Each part is supplied by at least one supplier, but multiple suppliers could potentiallysupply the same part.4. The following information must be stored for each product: description.Proprietary information of ACME Technologies™. Do not communicate with unauthorised thirdparties.
You've recently been hired as a Database Administrator at KCA University.Some departments have computers, while others have to rely on manual data storage.Your first task is to create a plan for how KCA University will implement a database management system in the next six months.Give an outline of at least 5 stages needed to complete this assignment, including specifics for each step.
In view of the recent wave of Covid-19 , University is asked to implement a rigorous monitoring and Control function on all activities of Faculty and Students . For the reporting and analyzing the CMS academic data, management want to hire services of a Database Administrator. Prior to go for advertisement, you are to go through the Job analysis process. As HRM expert: - 1. what information would you collect from the concern University stakeholders.? 2. Write down the Process of Job Analysis.? 3. After getting all the information, finalize the Job Summary, Job specification and Description of the desired position.? Note: This question is from Human Resource Management
When implementing a new database management system it is important to consider the _________________ Question 46 options: 1) Cultural aspect 2) Managerial aspect 3) Technical aspect 4) All of the above
Submit a system requirement for cloud computing database management system. The system requirements model is to have combination of sections: requirements model business process model, data flow diagram data dictionary object model use case diagram. draw the image diagram and include text to ensure that the diagram has proper context within the overall system requirements model through written explanations. Your audience is IT management and the IT project team.
A small training college has decided to extend and replace its existing database system. The project has received board approval and the required functional changes and additional requirements have been agreed with the users. A project manager has been appointed and has been allocated a project team of three database analysts, three development programmers and one tester, with selected users being made available for acceptance testing. An outline project schedule for the development and implementation phases has been drawn up. It includes the following tasks and related staff allocations. Task Description Duration (weeks) Staff A Define required new database functionality 4 Database Analyst DA1 B Define new data entry and update requirements 3 Database Analyst DA2 C Define new data analysis and report outputs 3 Database Analyst DA3 D Define database transfer rules 2 Database Analyst DA3 E Code and test extended database tables…
Assume your boss has assigned you the task of selecting a business database management system Make a list of technical checks. problems and considerations to consider throughout the selecting process