Question

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.

Answer 1

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