Posted: May 15th, 2022

OMR2002 BUSINESS INFORMATION SYSTEMS Assessment Practical Skills – Database Application Assignment

Assessment 4_COMR2002BIS.docx Page 1 of 8
ASSESSMENT BRIEF
Subject Code and Title COMR2002 BUSINESS INFORMATION SYSTEMS
Assessment Practical Skills – Database Application Assignment
Individual/Group Individual
Length Add the required length for the assignment, presentation,
discussion post, etc.
Learning Outcomes 1. Recognise the range of cultural, security, privacy and
ethical issues confronting individuals and
organisations as consequence of using Information
Systems.
2. Apply practical skills in the major functions of
spreadsheet and database tools.
3. Communicate with IT professionals, stakeholders and
user groups of information systems.
Submission By 11:55pm AEST/AEDT Sunday of Week 12
Weighting 40 %
Total Marks 40 marks
Context:
The aim of this assessment is to assess the student’s ability to solve business problems using
database design tool and software. Weekly online practical work will help students to
complete this assessment. 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
Instructions:
Students are expected to develop a database for the case study provided. Students need to
design and implement the database using LibreOffice Base or Microsoft Access. Students will
be having several database- related practical activities during the semester and each practical
activity will assist you in completing of your assignment. Additional information you need in
Assessment 4_COMR2002BIS.docx Page 2 of 8
developing the database will be provided during the week you are expected to implement a
practical activity.
The following are the list of requirements:
• Analysis of the problem and designing the (20% mark)
• Create database tables using LibreOffice Base (5% mark)
• Create queries and forms using LibreOffice Base and SQL (5% mark)
• Report on Impact using the technology (10%)
Students need to submit the following:
1) A word document containing:
a) Introduction – a summary of the case study . What are the issues? Discuss how
database will be help solve some of the issues identified.
b) Database
• explanation of the database development activities
• E-R Diagrams created
• Database tables created using LibreOffice Base
• SQL queries and the reports generated by those queries
c) Impact of using technology (at least 500 Words)
▪ Discuss how Business Information Systems are being used in the case study (go to
their website: tourdownunder.com.au/ and analyse from there)
▪ Discuss the cultural, security, ethical and privacy issues in using IS and IT
2) LibreOffice Base or Microsoft Access files used in creating the tables, queries and forms
Assessment4_COMR2002BIS.docx Page 3 of 8
Assessment
Attributes Fail (Unacceptable) Pass
(Functional)
Credit
(Proficient)
Distinction
(Advanced)
High Distinction
(Exceptional)
Documentation and
Analysis
10
The document is incomplete and do
not meet the minimum requirements.
Report was written very poorly with
grammatical and spelling errors; less
than required length; and incomplete
and incorrect citations.
Critical business issues and use of
database were not identified (or
incorrectly identified).
0-4
Document contains the
minimum requirement.
Grammatical and
spelling errors are
present; document
presentation needs to
be improved.
Some inefficiencies and
ineffectiveness of the
current processes were
identified. Use of
database were
discussed by in general
terms but did not
relate directly to the
issues identified.
5
Document contain the
required contents.
Summary of the case
study and database
development activities
are presented well.
Most inefficiencies and
ineffectiveness of the
current processes were
identified. Use of
database were
discussed in some
detail but did not
answer all issues
identified.
6
Document exceeds
minimum
standards.
Summary of the
case study and
database
development
activities are
presented
excellently.
Most inefficiencies
and
ineffectiveness of
the current
processes were
identified. Use of
database were
discussed in detail
and answered all
the identified.
7-8
Document exceeds
minimum standards
and exhibit high
quality presentation.
Summary shows
sophisticated
understanding of the
case study and
database
development
activities. Document
is presented and
formatted excellently.
All inefficiencies and
ineffectiveness of the
current processes
were identified. Use
of database were
discussed in great
detail and answered
all issues identified.
9-10
E-R Diagram E-R Diagram created was incomplete
and incorrect.
E-R diagram created
was complete but
some attributes and
E-R diagram created
was complete.
E-R diagram
created was
complete.
E-R Diagram created
was complete and
correct.
Assessment4_COMR2002BIS.docx Page 4 of 8
10
More than 50% of the entities,
attributes and relationships identified
were incorrect.
1-4
relationships were
incorrect.
Some entities
identified should not
be an entity.
More than 50% of
attributes were
missing (or incorrect)
and incorrect
relationships
identified.
5
All entities identified
were correct.
Less than 50% of
attributes and
relationships were
missing or incorrect.
6
Identified entities
were correct and
complete.
Attributes were
correct and
complete.
Some relationships
were missing (or
incorrect)
7-8
All entities, attributes
and relationships
were correctly
identified.
9-10
Database Tables 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.
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
incorrect.
Relationships are not
translated to tables
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)
Database table is
complete and
correct.
All entities are
correctly and
completely
translated into
tables.
Attributes and
types of attributes
were correctly
identified.
Database table is
complete and correct.
All entities are
correctly and
completely translated
into tables.
Attributes and types
of attributes were
correctly identified.
All data in the table
were entered.
Assessment4_COMR2002BIS.docx Page 5 of 8
5 1-2
(primary keys and
foreign key are
incorrect)
Some data in the table
were entered.
2.5
All data in the table
were entered.
Most of the attributes
have correct types.
3
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).
4
All table relationships
were correct (primary
and foreign keys and
their relationships
were all correctly
identified)
5
SQL Reports and
Forms
SQL queries and generated reports
were mostly incorrect.
Forms were not created
More than 50% of the
SQL queries and
reports were correct.
Forms were created
but not fully
functioning.
More than 75% of the
SQL queries and
reports generated
were correct.
All elements of the
forms were created
and have been linked
to the tables.
All SQL queries and
reports generated
were correct.
All elements of the
forms were
created and all
have been linked
to the tables.
Most of the data
can be added and
correctly saved in
the tables.
Forms were
designed
appropriately.
All SQL queries and
reports generated
were correct.
All elements of the
forms were correctly
created, have been
linked to the tables,
and can correctly
save data entered.
Forms have very good
design.
Assessment4_COMR2002BIS.docx Page 6 of 8
5
1-2 2.5 3 4 5
Critical reasoning and
presentation of
emerging
technologies and the
arguments used in
defending issues in
culture, ethics,
security and privacy
The Business Information Systems (BIS)
identified are not appropriate.
Makes assertions about the use of BIS
and its impact that are not justified.
BIS identified is
appropriate but
reasons were not fully
justified.
Some issues were
justified by arguments
and not merely
assertions.
BIS identified is
appropriate and
arguments were
presented to justify the
use of the technology
in the organisation.
Takes into account the
complexities of the
issues of using BIS.
Other viewpoints were
acknowledged.
Justifies any
conclusions reach with
arguments and not
merely assertions
BIS identified is
highly appropriate
for the
organisation and
arguments
presented to
justify the
appropriateness of
the technology to
the organisation is
expertly
presented.
Accurately takes
into account the
complexities of the
use of BIS in the
organisation.
Justifies any
conclusions
reached with welldeveloped
arguments and
Emerging technology
identified is highly
appropriate for the
organisation. The
technology is
innovative and
arguments presented
to justify the
appropriateness of
the technology to the
organisation is
expertly presented.
Accurately takes into
account the
complexities of the
issues of introduction
this new technology
to the organisation.
Limitations of the
proposed technology
were also
acknowledged.
Assessment4_COMR2002BIS.docx Page 7 of 8
10 1-4 5 6
substantiated by
research.
7-8
Justifies any
conclusions with welldeveloped arguments
and well-articulated
viewpoint on the
issues of using the
proposed technology
and substantiated by
research.
9-10
Assessment4_COMR2002BIS.docx Page 8 of 8

Check Price Discount

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