ACCT6001 Assessment 4 – Database Application XXXXXXXXXXPage 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
usiness 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 XXXXXXXXXXPage 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
udget 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 numbe
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 li
eBase or Microsoft Access
3. You need to create the following forms for data entry:
a. Employee Form
. 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
. 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 XXXXXXXXXXPage 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
. List of all the suppliers’ information
SUBMISSION REQUIREMENTS:
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) IT controls needed
e) Ethical, privacy and security issues
2) Li
eOffice Base/Microsoft Access files used in creating the tables, forms, queries and
eports
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 XXXXXXXXXXPage 4 of 7
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 5 of 7
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.
Tables are not
normalised.
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).
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 co
ect)
All data in the table were
entered.
Most of the attributes
have co
ect types.
Some tables are
normalised.
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).
All tables are normalised to
third normal form.
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)
All tables are normalised to
third normal form.
Points 19-20
ACCT6001 Assessment 3- Excel Spreadsheet XXXXXXXXXXPage 6 of 7
Queries