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:

1. 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.
2. Create the tables, forms, reports and queries using libreBase or Microsoft Access
3. You need to create the following forms for data entry:
   1. Employee Form
   2. Project Form
   3. Supplier Form
4. 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
5. 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:

1. 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
2. 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