Assessment 1, MIS602 Page 1 of 4
ASSESSMENT 1 BRIEF
Subject Code and Title MIS602 Data Modelling and Database Design
Assessment Modelling Report
Individual/Group Individual
Length N/A
Learning Outcomes The Subject Learning Outcomes demonstrated by successful
completion of the task below include:
a) Examine the role of data in an organisation, and develop
solutions related to the creation, storage and
management of organisational data.
c) Apply contemporary database modelling to identify and
address anomalies in data and recommend solutions.
Submission For 12-week Duration: Due by 11:55pm AEST Sunday end of
Module 2 (Week 4)
For 6-week Duration: Due by 11:55pm AEST Sunday end of
Module 2 (Week 2)
Weighting 30%
Total Marks 100 Marks
Task Summary
This assessment requires you to prepare a modelling report that demonstrates your ability to
assess business requirements along with a logical design that could be implemented in a
relational database management system.
Context
When preparing to implement a new information system, it is essential that the initial design
is well thought out from the outset. Modifying the database after implementation can often
be an expensive process in terms of time, effort and cost. Often the first engagement step is
to conduct interviews and workshops with end users and business subject matter experts to
get a better understand of how the business runs. The output of these workshops becomes
the foundation for the database design.
Assessment 1, MIS602 Page 2 of 4
Task Instructions
Please read the attached MIS602_Assessment 1_Case Study.
Based on the information provided in the case study, prepare a modelling report to answer
the following tasks:
Task 1: An entity relationship diagram including all the significant entities, attributes
and their relationships. Use Crow’s foot notation.
Task 2: A relational model showing all fields, primary keys, foreign keys and
concatenated keys. Your relational model should be in third normal form. List any
assumptions/business rules you have made.
Task 3: A sample dummy input screen of scheduling an interview for one of the
shortlisted candidates. You have to make sure all the data requirements are being
captured.
You may use any tool you like to create this sample screen. Write a brief paragraph
of about 200 words discussing the following:
? Does your database design allow the storage of all the required
information?
? What changes, if any, did you make to your initial ER diagram and relational
model after you created the sample input screen?
The front-end or user interface design enables accessing the data stored in a database.
Prototyping the interface also enables capturing initial system and data requirements.
Submission Instructions
Please compile all the three tasks into a single word document and submit via the Assessment
1 section found in the main navigation menu of the subject’s Blackboard site. The Learning
Facilitator will provide feedback via the Grade Centre in the LMS portal. Feedback can be
viewed in My Grades.
Academic Integrity
When submitting their assessment task, students will be asked to declare the academic
integrity of their assessment by completing and signing an assignment cover sheet. You can
find the assignment cover sheet here
All students are responsible for ensuring that all work submitted is their own and is
appropriately referenced and academically written according to the Academic Writing Guide.
Assessment 1, MIS602 Page 3 of 4
Students also need to have read and be aware of Torrens University Australia Academic
Integrity Policy and Procedure and subsequent penalties for academic misconduct. These are
available at https://www.torrens.edu.au/policies-and-forms.
Students also must keep a copy of all submitted material and any assessment drafts.
Special Consideration
To apply for special consideration for a modification to an assessment or exam due to
unexpected or extenuating circumstances, please consult the Assessment Policy for Higher
Education Coursework and ELICOS and, if applicable to your circumstance, submit a
completed Application for Assessment Special Consideration Form to your Learning
Facilitator. These documents are available at https://www.torrens.edu.au/policies-andforms
Assignment 1, MIS602 Page 4 of 4
Assessment Rubric
Assessment Attributes Fail
(Unacceptable) 0-49%
Pass
(Functional)
50-64%
Credit
(Proficient) 65-74%
Distinction
(Advanced)
75 -84%
High Distinction
(Exceptional)
85-100%
Entity relationship diagram (40%
)
The ER diagram does not have to be
in 3NF. i.e. it can contain many
to many relationships
Only a few entities
identified and labelled.
No relationships
identified.
Most entities identified
and labelled. Most
relationships
identified.
All entities identified and
labelled.
All relationships identified.
Most cardinality is correct.
Most Participation is correct.
All Relationships
meaningfully labelled.
Primary key labelled for
entities.
All cardinality is correct.
All participation is correct.
Primary keys labelled for
many-to-many
relationships. Some
non-key fields
labelled.
Overall, a well-presented
entity relationship
diagram.
Relational model (40%)
The relational model needs to be in
3NF and free from anomalies
Only a few entities
converted to tables.
Design is not in third
normal form.
No list of assumptions/
business rules.
Most entities converted
to tables. Most fields
listed. Design is in third
normal form. List of
assumptions/business
rules provided.
All entities converted to
tables. All fields listed.
Most many-to-many
relationships deconstructed
into new tables. Primary
keys correctly underlined.
All many-to-many
relationships
deconstructed into new
tables. Foreign key
correctly underlined.
Any multi-valued
attributes deconstructed
into new tables. Any
selfjoins identified. A
well-presented relational
model.
Sample screen (20%)
Sample screen of the online order
form.
Discuss how the database design
allow the storage of all the required
information and the changes made
to the initial ER
diagram and relational model
Sample screen does not
capture the
requirements of the
order.
No discussion paragraph
provided.
Screen captures most of
the requirements for the
order.
Discussion paragraph
does not address the key
points.
Screen captures all of the
requirements for the order.
Discussion paragraph is
provided.
All screen fields correctly
mapped to a field in the
relational model.
Discussion paragraph is
well written and addresses
the key points.
All screen fields correctly
and accurately map to a
field in the relational
model.
Well-presented sample
screen along with a
discussion paragraph that
addresses the key points
with clarity and detail.