ACCT6001 Accounting Information Systems

Task:

1.Explain the characteristics of relational databases and their role in creation and communication of business intelligence.  

2.Identify and assess IT controls, auditing, ethical, privacy and security issues with respect to information.  

3.Apply technical knowledge and skills in creating information for the workplace using spreadsheets and relational databases.  

4. Communicate with IT professionals, stakeholders and user groups of information systems. 

Context:  

The aim of this assessment is to assess the student’s ability to solve business problems using database design tool and software. It also aims to enable students to think about the impacts of using IT in Businesses and communicate key issues through a written report.    

Many companies depend on the accurate recording, updating and tracking of their data on a minute-to-minute basis. Employees access this data using databases. An understanding of this technology allows business professionals to be able to perform their work effectively.  

The following are the list of requirements:  

•Explain why is the organisation needs to use a database.  

•Create an E-R Diagrams using Diagram Editor  

•Convert the E-R diagrams to tables and convert to Third Normal Form  

•Create database tables using LibreOffice Base   

•Create queries and forms using LibreOffice Base and SQL   

•Identify IT controls needed and ethical, privacy and security issues the organisation might encounter when using databases.