ACCT6001 Accounting Information Systems

ACCT6001 Accounting Information Systems - Assignment Problem

Reference no: EM132408014

ACCT6001 Accounting Information Systems, 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.

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:

You are expected to develop a database given the same organisational brief used in assessments 1-3. 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.

Reference no: EM132408014

Questions Cloud

Sequences of branches that are indicating the same outcome : A decision tree can contain some duplicates, i.e. there are at least two sequences of branches that are indicating the same outcome.

MBA600 Capstone Assignment - Recorded Video and Slides : MBA600 Capstone Assignment - Recorded Video and Slides, Assessment Help and Solution, Kaplan Business School, Australia. Analysis of the external environment

Discuss difference between economic value and social value : My initial answer was not acceptable by my professor. the response needs more "meat". Discuss the difference between economic value and social value

How are employees motivated in the organization : How are employees motivated in the organization? Some of the motivation techniques used may be encompassed in pay and benefits

ACCT6001 Accounting Information Systems - Assignment Problem : ACCT6001 Accounting Information Systems Assignment Help and Solutions, Laureate International Universities, Australia-Identify and assess IT controls.

What does the organization do : What does the organization do? What line of business are they in? What products/services do they offer?

Communication specialist at warby parker : You work as a communication specialist at Warby Parker, reporting to co-CEO David Gilboa. Using the skills you've been practicing in this course

Formulate a research proposal and design : Formulate a research proposal and design this into a workable research plan and Design and manage a business critical independent applied research.

MIS605 Systems Analysis and Design - The Prototype : MIS605 Systems Analysis and Design Assignment Help and Solution - Laureate International Universities, Australia. Part A - The Prototype

User Account

All Pages