ACCT6001 Accounting Information Systems Assignment

Reference no: EM132410573

ACCT6001 Accounting Information Systems Assignment - Laureate International Universities, Australia

Assessment - 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.

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.

CLIENT BRIEF - NIKO APPAREL MANUFACTURERS (NAM)

NAM'S DATABASE REQUIREMENTS:

1. NAM needs a new database designed and implemented given the information provided above.

2. They also need the following forms created:

a. Customer Information Form

b. Sales Representative Form

c. Order Form

d. Product Information Form

3. The following are some of the queries that should be answered by the database:

a. List of all products they are selling (product id, product name, category).

b. List of all the customers (customer no. and customer name) who lives in the state of Victoria (VIC).

c. List of all sales representatives with commission rate greater than 5%.

d. List of all customers (customer no. and customer name) and their sales representatives name.

e. List of all sales representatives no., sales rep name, product no., product name ordered during the month of May.

4. Priority reports that are needed are the following:

a. List of products (Product, id, product name, category, product price and quantity on hand).

b. List of all customers (customer no., customer name, address) with balances greater than 5000.

c. List of sales representatives (sales rep no., sales rep name) and their commission.

Report should show in order (from highest to lowest) the sales rep commission.

Instructions - Students are expected to develop a database given the same organisational brief used in assessments. Students need to design and implement the database using LibreOffice Base. Additional information is provided below and some tasks will be done during the week you are expected to implement a practical activity.

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.

Outcome to be submitted: 1) A word document containing:

a) Introduction - a summary of the case study

b) Justification of the use of database

c) Database Design: E-R Diagram

d) IT controls needed

e) Ethical, privacy and security issues

2) LibreOffice Base 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.

Reference no: EM132410573

Questions Cloud

List the 4 steps in the control cycle : List the 4 steps in the control cycle. Budgetary control is a common traditional example of managerial control: describe how managers

How administrators may apply systems theory in the work : For this Assignment, consider how administrators of human services organizations may apply systems theory in their work. Also, consider what you have discovered

The passage that you have chosen and translated : Discuss briefly the significance of the passage that you have chosen and "translated."

Key advantages of the structure you are proposing : What are the key advantages of the structure you are proposing? Are there any disadvantages?

ACCT6001 Accounting Information Systems Assignment : ACCT6001 Accounting Information Systems Assignment Help and Solution - Laureate International Universities, Australia. Assessment - Database Application

Assess the viability of an arrange change : Depict Measurements that can be utilized to assess the viability of an arrange change and clarify for what reason is it regularly hard

Discuss some problems with milton depiction of gender : Compare and contrast Eve with other heroines that we have encountered in our readings. AND / OR Discuss some problems with Milton's depiction of gender.

Describe the obsessive compulsive personality disorder : Choose one of the disorders listed below and present a paper from the point of view of someone who has this DSM-5 diagnosis. The paper should be one and a half.

What type of short story do you want to tell : In preparation for beginning your short story, consider the following questions: What type of short story do you want to tell? Which genre characteristics will.

User Account

All Pages