99

1) The Sales Transaction must be made atomic. This is useful to prevent possible loss of updates. Through making the transaction atomic, partial updates to the database are avoided. In this transaction, all operations must occur or none occurs. It is an irreducible transaction therefore it cannot be said to be in progress. This transaction jewelry items and money are not lost or created if the transaction fails.

2) Different groups need different processing rights depending on the transactions they should be allowed to perform. The managers need to have most of the privileges. Managers should have the rights to enter data into the enter data in the JEWELRY_ITEM table. Managers should be allowed to make price adjustments. The managers need to have rights to sales transactions as well as acceptance transactions. Managers should have the privilege to create sessions, create tables, selection of rows from tables made by other users and the execution of other users’ procedures.

3) The administrative personnel need to have privileges to do the acceptance transactions. The administrative personnel should have the rights to perform sale and acceptance transactions. The administrative personnel will be able to create sessions and create tables.

System administrators should have the rights to do the sales and acceptance transactions. System administrators will have the rights to create sessions and create tables (Oracle, 2016).

.

4)Backing up of information is very essential in any organization. James River Jewelry has been backing up its information in a second computer in the network as well as making a copy of the database on a monthly basis in a CD which is stored in a manager’s house. While this backup strategy can be viewed as effective, it is important not to take chances in the maintaining a good backup for the business organization. With the improvement of technology, there is the need of James River Jewelry to take advantage of the technology. For better backup and recovery for the business, there needs to be a comprehensive plan developed to serve the organization in case of anything. With numerous cloud providers available, storing the information in cloud will be important in ensuring that there is an easy restoration of databases which helps in the continuity of business.