Question

In: Computer Science

Your company is creating a new sales system. These are some of the concerns: Ease of...

Your company is creating a new sales system. These are some of the concerns:

  • Ease of data entry
  • Accuracy of data entered, stored, and managed
  • Ability to create reports
  • Cost to build and maintain the system

Role of Chief Information Officer (CIO) is assigned to you: Chief Information Officer (CIO): All IT is overseen by the CIO. The CIO is over the hardware, software, IT processes, management, support and security and privacy of all systems within the organization

To prepare for this Discussion, gather information from the library and research other web resources. Write a plan describing your role in developing the system, your tasks based on your role, and your input to a plan for developing the system.

The initial response should be 400–500 words with APA references.

Solutions

Expert Solution

As the system should be easily used for data entry we need to develop a good user interface which can easily be used by the people who is not familiar with thorough knowledge of using computer. The user interface will make sure that the data entry job will be easier.The data should be stored and managed in a good way in order to make the system efficient.For that we can use different normalization  like 1NF, 2NF, 3NF, BCNF etc . We are using normalization in order to make the retrieval and managing of data quite easier. We can use different locking mechanisms like One Phase Locking , Two Phase Locking etc to prevent the use of shared variables in the transaction during the operations that are doing in the data. In order to preserve the accuracy of the data that are stored and managed we have to ensure the that ACID ( A-Atomic , C-Consistency , I-Isolated , D-Durability ) property is satisfying. The ACID property will ensure that the operation that is performed to the data will lead to a success state . We can also use rollback methods if the transactions are failed .The rollback mechanisms will ensure that the it will take the state of the system to the previously committed state and avoid the prone of error during the operation and managing of data in the database . Hence we can ensure the accuracy of the data that are being stored , retrieved and managed in the database.

For the generation of report we can depend a program that uses the data's from the database which are stored with the help of user interface .By knowing the format of the report that we need and with the help of the available data's in the database we can easily generate report with the help of computer programming. There are so many programming languages are available in this era and we can use the one which is efficient and simple. I mostly prefer Python because it is easy to code and it is very simple. Most of the programmers are now a days using Python. As the python is an open source language and there are so many free databases available in the internet the development cost of the system will be less. The development and maintaining cost mainly depends on the database that we are using and the server that we are using . If the data traffic is less then we can use free hosting site that provides services. If it is a huge traffic system the we have to switch to a provider who offer more powerful services , then it will lead to a high developmental and maintenance cost  because high perforce will cost high.

References :

Normalization - https://www.guru99.com/database-normalization.html

User Interface - https://techterms.com/definition/user_interface

ACID Property - https://www.geeksforgeeks.org/acid-properties-in-dbms

Locking - http://ecomputernotes.com/database-system/rdbms/type-of-lock-in-dbms

Rollback - https://www.techopedia.com/definition/9229/rollback

Commit - https://www.techopedia.com/definition/16/commit

Transaction - https://www.tutorialspoint.com/dbms/dbms_transaction.htm

Python - https://en.wikipedia.org/wiki/Python_(programming_language)

Traffic - https://en.wikipedia.org/wiki/Network_traffic


Related Solutions

our company is creating the database for the sales system. These are the major components: Database...
our company is creating the database for the sales system. These are the major components: Database design User entry form design Report design Access and authentication Maintenance You are assigned as an IT manager. For this Discussion, gather information from the library and research other web resources. Write a plan describing your role in designing, developing, managing, and supporting the database.
Your company is tasked with creating software for a home security system.
1. Consider the following:Your company is tasked with creating software for a home security system. The software helps manage all the security cameras and devices installed in the house, relays communications between all parties, and provides a “dashboard” mechanism for homeowners and security personnel to access and monitor.Develop 8 to 10 requirements concerning this scenario.2. What is a “recommendation system” and how can it assist in requirements engineering? What tools can be used to assist in requirements gathering?
1. What are some of the most significant health concerns in your community? Are these concerns...
1. What are some of the most significant health concerns in your community? Are these concerns that are likely to be shared by other communities in your country and in other parts of the world? Could these problems be considered global health issues? 2. Sketch out a causal web (see example below) for a relatively common disease in your country, adding at least 10 risk factors to the figure. Based on the arrows on you1. 3. Create a brief disease...
A company is considering creating and selling a new type of cookies. Start your paper by...
A company is considering creating and selling a new type of cookies. Start your paper by composing some hypothetical, brief details that summarize what the organization is, what it does, and the product they may launch. Then, create a report explaining the research process that should be used by the company to make this decision. Your report should answer the following questions: What is the research question? What is the proposed research? How would you design the research project? What...
Review the central concepts of story theory (intentional dialogue, connecting with self-in-relation, and creating ease), and...
Review the central concepts of story theory (intentional dialogue, connecting with self-in-relation, and creating ease), and describe how its use will strengthen the care you provide to clients.
Mcdonalds needs to have a new sales, inventory and service system designed. You have conducted some...
Mcdonalds needs to have a new sales, inventory and service system designed. You have conducted some interviews and reduced requests down to the following key capabilities of the system: (1) Customer Will order food and make the payment (2) Store shift leader Will hold the rights to change the menu and enter the  POS system to make any changes (3)POS System Serve as a backbone for doing the credit / debit card transaction.(4)   Food Preparation Employee This person receives the order placed...
21) Sales Forecasting: You were asked at your new company to forecast sales for the coming...
21) Sales Forecasting: You were asked at your new company to forecast sales for the coming year. Utilizing the Compound Average Growth Rate, you have gone out and collected the data for the prior three years (noted below). Using this data, compute the a. compound growth rate for each of the years b. forecast next year’s sales by using the two-year average growth rate. Year Sales 2012 2,400,000 2013 2,750,000 2014 3,500,000 2015 ?
You are creating a system to promote a chain of fancy restaurants around the world. Your...
You are creating a system to promote a chain of fancy restaurants around the world. Your system will use an array of dynamically allocated restaurants and should allow adding, removing and modifying restaurants. Your array will contain up to 100 restaurants. You will create an input .txt file with 20 command of your choice that will include: Adding a restaurant, by searching the first not-null cell in the array. Removing a restaurant, by searching the restaurant to be removed, deallocating...
Your company is considering the purchase of a new production system with an installed cost of...
Your company is considering the purchase of a new production system with an installed cost of $1,250,000. The cost will be depreciated on a straight-line basis to zero over the five-year life of the project, and the system can be sold at the end of the project for $225,000. It will provide additional revenue of $685,000 in the first year, and the additional revenue is expected to grow 5% per year thereafter. The associated cost of goods sold is estimated...
1. Explain the concerns some observers have about interest groups in the U.S. political system. Address...
1. Explain the concerns some observers have about interest groups in the U.S. political system. Address the membership of those groups, the resources they use, and the effects they have. Use examples wherever possible.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT