Posted: May 15th, 2022

ACCT6001 Assessment 4 – Database Application, Accounting Information Systems

ACCT6001 Assessment 4 – Database Application Page 1 of 7
ASSESSMENT BRIEF
Subject Code and Title ACCT6001 Accounting Information Systems
Assessment Assessment 4: Database Application
Individual/Group Individual
Length
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.
Submission By 11:55pm AEST/AEDT Sunday end of module 6 (week
12)
Weighting 30%
Total Marks 100 marks
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.
ACCT6001 Assessment 4 – Database Application Page 2 of 7
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:
a. Employee Form
b. Project Form
c. Supplier Form
4. The following are the queries that should be answered by the database:
a. List of all the projects’ information
b. List of all the projects titles, description, due date and activities per project
c. List of all information about the team members of each project
ACCT6001 Assessment 4 – Database Application Page 3 of 7
d. List all the projects that are due on December 2018
5. Priority reports that are needed are the following:
a. List of the materials that were delivered on November 18 and the name of their
suppliers
b. List of all the suppliers’ information
SUBMISSION REQUIREMENTS:
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/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
ACCT6001 Assessment 3- Excel Spreadsheet Page 4 of 7
Learning Rubrics
Assessment Attributes Fail
(Unacceptable)
Pass
(Functional)
Credit
(Proficient)
Distinction
(Advanced)
High Distinction
(Exceptional)
Points
Need for the
implementation of the
database
15%%
Unsatisfactory
explanation provided is
very general, lacks
detail, does not answer
the question.
Points 0-6
Satisfactory explanation
provided, several
justifications discussed, lack
detailed explanation.
Points 7-9
Good explanation provided,
several justifications
discussed. Explanations are
detailed but some are not
convincing.
Points 10-11
Very good explanation and
justification. Explanations are
convincing. Main problems
are identified and discussed in
details. Provided some
examples.
Points 12-13
Excellent explanation and
justifications provided. Main
problems are identified and
prioritised. Each problem is
discussed in detail. Examples
were provided for each
problem.
Points 14-15
E-R Diagram
15%
E-R Diagram is
incorrect.
More than 50% of the
entities, attributes
and relationships
identified are
incorrect.
Points 0-6
E-R diagram is complete
but some attributes and
relationships are
incorrect.
Some entities identified
should not be an entity.
Around 50% of attributes
are missing (or incorrect)
and incorrect
relationships are
identified.
Points 7-9
E-R diagram is complete.
All entities identified are
correct.
Around 25% of the
attributes and
relationships are missing
or incorrect.
Points 10-11
E-R diagram is complete.
Identified entities were
correct and complete.
Attributes were correct
and complete.
One or two relationships
were missing (or incorrect)
Points 12-13
E-R Diagram is complete.
All entities, attributes and
relationships are identified
correctly.
Points 14-15
ACCT6001 Assessment 3- Excel Spreadsheet Page 5 of 7
Database Tables
20%
Database tables are
incorrect and
incomplete.
E-R Diagram is not
correctly translated to
database tables.
Majority of the tables,
attributes are missing.
Not all entities were
translated into tables.
Tables are not
normalised.
Points 0-9
Database table is
complete.
All entities are translated
into tables.
Some attributes of the ER
Diagram are not in the
table and types of
attributes are incorrect.
Relationships are not
translated to tables
(primary keys and foreign
key are incorrect).
Tables are not
normalised.
Some data in the table
were entered.
Points -10-12
Database table is
complete.
All entities are translated
into tables.
Attributes are all present
and relationships among
tables are established
(primary keys and foreign
keys are mostly correct)
All data in the table were
entered.
Most of the attributes
have correct types.
Some tables are
normalised.
Points 13-15
Database table is complete.
All entities are correctly
and completely translated
into tables.
Attributes and types of
attributes were correctly
identified.
All data in the table were
entered.
Most table relationships
are correct (primary keys
and foreign keys and their
relationship have been
mostly correctly
established).
All tables are normalised to
third normal form.
Points 16-18
Database table is complete.
All entities are correctly and
completely translated into
tables.
Attributes and types of
attributes are correctly
identified.
All data in the table are
entered.
All table relationships are
correct (primary and foreign
keys and their relationships
are all correctly identified)
All tables are normalised to
third normal form.
Points 19-20
ACCT6001 Assessment 3- Excel Spreadsheet Page 6 of 7
Queries
20%
SQL queries and
generated are mostly
incorrect.
Complex queries are
not answered
Points 0-9
More than 50% of the
SQL queries are correct.
Complex queries are
incorrect.
Points -10-12
More than 75% of the SQL
queries are correct.
Complex queries are
mostly incorrect.
Points 13-15
Almost all queries are
correct (one or two
incorrect queries).
Some complex queries
were answered.
Points 16-18
All SQL queries are correct.
Can generate complex
queries.
Points 19-20
Forms and Reports
15%
Unsatisfactory forms.
Forms does not enter
data.
Reports are mostly
incorrect. No report
formatting used.
Points 0-6
Satisfactory forms. Some
links to the tables are not
functioning. Some data
cannot be entered in the
tables via forms.
Simple design
incorporated in the
forms. Not professional
looking.
More than 50% of the
reports are correct. No
report formatting used.
Points 7-9
Good forms. Most data
can be entered in the
tables via forms.
Some design were
incorporated in the forms
but not professional
looking.
More than 75% of the
reports are correct. Some
report formatting used.
Points 10-11
Very good forms. All
elements of the forms are
created. All data can be
entered via forms.
Design were incorporated
in the forms. Somewhat
professional looking.
Almost all of the reports
are correct (one or two
incorrect). Report
formatting used.
Points 12-13
Excellent form.
All elements of the forms are
created. All data can be
entered via forms.
Professional looking forms.
All of the reports are correct
Report formatting used
extensively.
Points 14-15
ACCT6001 Assessment 3- Excel Spreadsheet Page 7 of 7
IT Controls, Ethical,
Privacy and Security
Issues
15%
Makes assertions
about the IT controls,
ethical, privacy and
security issues that
are not justified.
Points 0-6
Some issues are justified
by arguments and not
merely assertions.
Points 7-9
Issues identified are
appropriate. Arguments
are presented to justify
the issues.
Takes into account the
complexities of the issues.
Other viewpoints were
acknowledged.
Justifies any conclusions
reach with arguments and
not merely assertions.
Points 10-11
Issues identified are
appropriate. Arguments
are presented to justify the
issues.
Accurately takes into
account the complexities of
the issues. Other
viewpoints were
acknowledged.
Justifies any conclusions
reach with well-developed
arguments and not merely
assertions.
Points 12-13
Issues identified are
appropriate. Arguments are
presented to justify the
issues.
Accurately takes into
account the complexities of
the issues and provided
examples. Other viewpoints
were acknowledged.
Justifies any conclusions
reach with well-developed
arguments and wellarticulated
viewpoint on the
issues and substantiated by
research.
Points 14-15

Check Price Discount

Study Notes, Research Topics & Assignment Examples: Prison Riots and Violence »FOREIGN DIRECT INVESTMENT