ACCT6001 Assessment 4 – Database Application XXXXXXXXXXPage 1 of 6
ASSESSMENT BRIEF
Subject Code and Title ACCT6001 Accounting Information Systems
Assessment Assessment 4: Database Application
Individual/Group Individual
Length 1500 words +/-10%
Learning Outcomes b) Explain the characteristics of relational databases
and their role in creation and communication of
usiness intelligence.
c) Identify and assess IT controls, auditing, ethical,
privacy and security issues with respect to
information.
d) Apply technical knowledge and skills in creating
information for the workplace using spreadsheets
and relational databases.
e) Communicate with IT professionals, stakeholders
and user groups of information systems.
Submission By 11:55pm AEST/AEDT Sunday end of module 6.2 (week
12)
For intensive mode: By 11:55pm AEST/AEDT Sunday
week 6/ end of module 6.2
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 XXXXXXXXXXPage 2 of 6
Instructions:
Students are expected to develop a database given the organisational
ief that will be
provided to you. Students need to design and implement the database using Microsoft Access
or Li
eBase.
The following are the list of requirements:
• Explain why the organisation needs to use a database.
• Create an E-R Diagram using Diagram Editor
• Convert the E-R diagrams to tables
• Create database tables
• Create queries and forms
• 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
) Justification of the use of database
c) Database Design: E-R Diagram
d) Analysis of the database
2) Database files used in creating the tables, forms, queries and reports
Criteria
• Need for the implementation of the database
• E-R Diagram
• Queries
• Forms and Reports
• Database Analysis
ACCT6001 Assessment 3- Excel Spreadsheet XXXXXXXXXXPage 3 of 6
Learning Ru
ics
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
inco
ect.
More than 50% of the
entities, attributes
and relationships
identified are
inco
ect.
Points 0-6
E-R diagram is complete
ut some attributes and
elationships are
inco
ect.
Some entities identified
should not be an entity.
Around 50% of attributes
are missing (or inco
ect)
and inco
ect
elationships are
identified.
Points 7-9
E-R diagram is complete.
All entities identified are
co
ect.
Around 25% of the
attributes and
elationships are missing
or inco
ect.
Points 10-11
E-R diagram is complete.
Identified entities were
co
ect and complete.
Attributes were co
ect
and complete.
One or two relationships
were missing (or inco
ect)
Points 12-13
E-R Diagram is complete.
All entities, attributes and
elationships are identified
co
ectly.
Points 14-15
ACCT6001 Assessment 3- Excel Spreadsheet XXXXXXXXXXPage 4 of 6
Database Tables
20%
Database tables are
inco
ect and
incomplete.
E-R Diagram is not
co
ectly translated
to database tables.
Majority of the
tables, attributes are
missing. Not all
entities were
translated into
tables.
Points 0-9
Database table is
complete.
All entities are translated
into tables.
Some attributes of the E-
R Diagram are not in the
table and types of
attributes are inco
ect.
Relationships are not
translated to tables
(primary keys and
foreign key are
inco
ect).
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 co
ect)
All data in the table were
entered.
Most of the attributes
have co
ect types.
Points 13-15
Database table is
complete.
All entities are co
ectly
and completely translated
into tables.
Attributes and types of
attributes were co
ectly
identified.
All data in the table were
entered.
Most table relationships
are co
ect (primary keys
and foreign keys and their
elationship have been
mostly co
ectly
established).
Points 16-18
Database table is complete.
All entities are co
ectly and
completely translated into
tables.
Attributes and types of
attributes are co
ectly
identified.
All data in the table are
entered.
All table relationships are
co
ect (primary and foreign
keys and their relationships
are all co
ectly identified)
Points 19-20
ACCT6001 Assessment 3- Excel Spreadsheet XXXXXXXXXXPage 5 of 6
Queries
20%
SQL queries and
generated are mostly
inco
ect.
Complex queries are
not answered
Points 0-9
More than 50% of the
SQL queries are co
ect.
Complex queries are
inco
ect.
Points -10-12
More than 75% of the
SQL queries are co
ect.
Complex queries are
mostly inco
ect.
Points 13-15
Almost all queries are
co
ect (one or two
inco
ect queries).
Some complex queries
were answered.
Points 16-18
All SQL queries are co
ect.
Can generate complex
queries.
Points 19-20
Forms and Reports
15%
Unsatisfactory forms.
Forms does not enter
data.
Reports are mostly
inco
ect. 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
eports are co
ect. No
eport formatting used.
Points 7-9
Good forms. Most data
can be entered in the
tables via forms.
Some design were
incorporated in the forms
ut not professional
looking.
More than 75% of the
eports are co
ect.
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 co
ect (one or two
inco
ect). Report
formatting used.
Points 12-13
Excellent form.
All elements