Q Prepare a memo to the top management team at Smith and Sons Limited explaining the advantages of a DBMS Home, - Prepare a memo to the top management team Question - Smith and Sons Limited has a flat-file processing system. The information-processing facility of the company is extensive. Different applications, such as order processing, production planning, inventory management, accounting systems, payroll, and marketing systems, use separate tape and disk files. You were running an accounting consultancy and considered the best consultant on the accounting information system. Therefore, Smith and Sons Limited has recently hired your consulting firm to investigate the possibility of switching to a database management system. Based on the above information, prepare a memo to the top management team at Smith and Sons Limited explaining the advantages of a database management system (DBMS). Also, discuss the necessity of a database administrator and the job functions this person would perform. Answer - There are various advantages of the database systems Data integration: The use of the database system provides the integrity of the data by using the constraints on the data. The files are combined in logical way and these files are made accessible to different systems. Data sharing: The authorized users can access the data easily and data can be stored at one place. Minimizing data redundancy: The redundancy in the data gets reduced. The delicacy in the data can be prevented using various constraints. Data consistency: The consistency of the data can be ensured as data is not stored at multiple places. Therefore, the update in the data does not affect the consistency of the data. Data independence: There is separation between the data and the programs. More security: Database management system enables the users to ensure more security. The security controls can be enforced on the data. The data can be encryoted with the use of the different encryption algorithms. Database administrator The database administrator is required for the storage and the management of the data in the database. Job functions To create database design for the storage of the data To create table for the storage of the data. To create multiple views of the database. To provide different access control privileges to the different users of the database. To design the maintenance procedures for the database. Related: Describe potential internal control weaknesses Explain the type of fraud that has taken place Prepare a memo to the top management team What controls are needed to reduce the risk of fraud Describe the controls that need to be implemented Advice regarding the typical process of having new AIS
Related :- Q Explain the type of fraud that has taken place explain the type of fraud that has taken place - List and explain in detail two contributing factors to the type of fraud that had taken place Q Describe potential internal control weaknesses describe potential internal control weaknesses - Describe potential internal control weaknesses in the above activities of MPS Limited. Discuss potential risks Q What do you understand by diversification what do you understand by diversification - What do you understand by diversification as a growth strategy? Explain the two types of diversification Q How does hedging arrangement reduce foreign currency risk exposure how does hedging arrangement reduce foreign currency risk exposure - HI6025 - How does it reduce the foreign currency risk exposure Q Provide explanation for capitalising the expenses provide explanation for capitalising the expenses - discuss and explain if an entity is considering revaluing its exploration and evaluation assets. Q Determine the interest rate implicit in the lease determine the interest rate implicit in the lease - HI6025 - Calculate the basic EPS for ABC Ltd for the year ending 30 June 2023 Q Calculate beta for stock G calculate beta for stock g - Use the single index model to compute the covariance between stocks G and H Q What the minimum risk combination of two assets what the minimum risk combination of two assets - If the assets are perfectly negatively correlated, what is the minimum risk combination of the two assets? Q Has any goodwill been acquired has any goodwill been acquired - discuss the potential for including associated legal fees into the cost of acquiring RedCarpet Q Treatment for assets that are not qualifying assets treatment for assets that are not qualifying assets - Explain the qualifying asset and how do we treat exchange rate differences