ACCT6001 - Accounting Information Systems - Database Application - IT Controls - Libre Office - E-R diagrams - Assignment Help

Assignment Task

Context:
The aim of this assessment is to assess the student’s ability to solve business problems using a database design tools 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.

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 a commission rate greater than 5%.
d. List of all customers (customer no. and customer name) and their sales representative's 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. The report should show in order (from highest to lowest) the sales rep commission.
Instructions:
Students are expected to develop a database given the same organizational 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 organization 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 organization might encounter when using databases.

The 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
• Normalized Database Tables
• Queries
• Forms and Reports
• IT Controls, Ethical, Privacy and Security Issues

This ACCT6001: Account And Finance Assignment has been solved by our Accounting And Financial Assignment Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.