ACCT6001 Accounting Information Systems

{`ASSESSMENT BRIEF 3
  Subject Code and Title :- ACCT6001 Accounting Information Systems
  Assessment :- Assessment 4: Database Application
  Learning Outcomes
  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.
  University:- Laureate International Universities
  `}

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.

CASE STUDY

DATABASE APPLICATION

You have been assigned as coordinator for a project management company. You will be managing several ongoing projects. As part of your job, you are supposed to keep track of its commercial projects, employee and the employees’ participation in each project. Usually, each project will have multiple team members, but some projects have not been assigned to any team member. Each employee can be assigned to one or more projects. Some employees can also be on leave and will not be working on any assignment. Project leaders usually need to know the following information about their team members:

Name
Address
Phone number,
Highest degree attained
Expertise (e.g. accounting, IS, marketing and finance)

For each project, the company must keep track of the project’s title, description, location, estimated budget and due date. For each project description, a list of associated activities is recorded and for each activity, a list of materials needed are also monitored. This list includes the material needed, cost, the date it was ordered, date expected to be delivered and actual delivery date. Each material can be sourced from different suppliers. As the coordinator, you need to monitor where the materials were sourced from. The following details you should know about the supplier:

name of supplier
address,
ABN
contact person
contact number

Instructions:

You need to design and develop a new database given the information provided above. Create the E-R diagram, translate to relational schema and then normalise.
Create the tables, forms, reports and queries using libreBase or Microsoft Access
You need to create the following forms for data entry:
1. Employee Form
2. Project Form
3. Supplier Form
The following are the queries that should be answered by the database:
1. List of all the projects’ information
2. List of all the projects titles, description, due date and activities per project
3. List of all in formation about the team members of each project
4. List all the projects that are due on December 2018
Priority reports that are needed are the following:
1. List of the materials that were delivered on November 18 and the name of their suppliers
2. List of all the suppliers’ information

SUBMISSION REQUIREMENTS:

A word document containing:
1. Introduction - a summary of the case study
2. Justification of the use of database
3. Database Design: E-R Diagram
4. IT controls needed
5. Ethical, privacy and security issues
LibreOffice Base/Microsoft Access files used in creating the tables, forms, queries and reports

Criteria

Need for the implementation of the database
E-R Diagram
Normalised Database Tables
Queries
Forms and Reports
IT Controls, Ethical, Privacy and Security Issues

Australia Universities

ACT

Australian Catholic University

Australian National University

Bond University

Central Queensland University

Charles Darwin University

Charles Sturt University

Curtin University of Technology

Deakin University

Edith Cowan University

Flinders University

Griffith University

Holmes Institute

James Cook University

La Trobe University

Macquarie University

Monash University

Murdoch University

Queensland University of Technology

RMIT University

Southern Cross University

Swinburne University of Technology

University of Adelaide

University of Ballarat

University of Canberra

University of Melbourne

University of Newcastle

University of New England

University of New South Wales

University of Notre Dame Australia

University of Queensland

University of South Australia

University of Southern Queensland

University of Sydney

University of Tasmania

University of Technology Sydney

University of the Sunshine Coast

University of Western Australia

University of Wollongong

Victoria University

Western Sydney University

Year 11 - 12 Certification Assignment

Australian Capital Territory Year 12 Certificate

HSC - Higher School Certificate

NTCE - Northern Territory Certificate of Education

QCE - Queensland Certificate of Education

SACE - South Australian Certificate of Education

TCE - Tasmanian Certificate of Education

VCE - Victorian Certificate of Education

WACE - Western Australia Certificate of Education