Assessment Artefact: Database design Assessment task: Assignment 1 ITECH7410 Software Engineering Methodologies Individual Assig…

FIND A SOLUTION AT Academic Writers Bay

ASSESSMENT GUIDE
ITEC200: Data and Information Management, Semester 1, 2021
Assessment 2
Assessment Artefact: Database design
Weighting [30%]
Why this assessment?
What are the types of employability skills that I will acquire upon completion of this
assessment?
Assessment Overview:
Purpose, as written in the EUO
Due date:
Friday 30/4/2021 – 5 pm (Week 8)
Weighting:
30%
Length and/or format:
SQL Code + Report + Recorded Video Presentation
Learning outcomes assessed
LO2, LO3
Graduate attributes assessed
GA1, GA5, GA10
How to submit:
Via LEO
Return of assignment:
Within 2-3 week of submission date
Assessment criteria:
Rubric: see end of document
• To enable students to develop professional skills through the application of theoretical knowledge and skills
in designing a database.
Skill Type
Developed critical and analytical thinking

Developed ability to solve complex problems

Developed confidence to learn independently

Developed knowledge in the field study

Developed work-related knowledge and skills

2
Context
Australian Department of Social Services has developed a data collection and reporting system called Data
Exchange.
The Data Exchange provides flexible ways for community service providers (e.g. charities, NGOs, …) to submit
performance information to the department. In return, the Data Exchange delivers two-way data sharing between
funding agencies and organisations in a range of engaging reports. This data helps them find smarter and more
efficient ways of improving service delivery and understanding the outcomes being achieved for vulnerable
individuals, families and their communities.
The concepts and terminology associated with collecting and reporting client level data from Australian Department
of Social Services’ Data Exchange is provided the “Data Exchange Protocols” document.
Instructions
Read the “Data Exchange Protocols” document (Pages 4-10, 16-27 and 46-57).
Based on the information provided about the data requirement of the Data Exchange system, develop the logicallevel database design by creating an Entity Relationship (ER) diagram.
The ER diagram should include Entities, Attributes and keys, and Relationships. Model relationships in this
assignment using Chen Notation.
To develop a well-designed ER diagram:
1. Identify all Entities, their Attributes and relationships between the entities.
2. Use ERDPlus (https://erdplus.com) to draw ER diagram.
3. Add connectivity, cardinality, and constraints to the diagram.
4. Resolve any many-many relationships and one-to-one relationships.
5. Specify the appropriate Primary keys and Foreign keys on the ERD.
6. Apply normalisation to resolve any anomalies. Your tables must be at least in the third normal form (3NF).
7. Using ERDPlus convert the ERD to Relational Schema.
8. Create a word document, with a title page including your student ID, name, unit name & title, assignment
number. Paste the ER diagram and Relational Schema in a Word document. Also, clearly state any
assumptions that you make.
9. Write the SQL Code for creating the database tables. You can manually write the SQL code in a text file or
use ERDPlus to generate the SQL code. The SQL code generated by ERDPlus may need some tweaks
depending on how detailed is your ERD diagram. For example, if you have not added some constraints on
the ERD, they will not be included in the generated SQL code and you will need to add them manually.
10. Using MySQL Workbench, create a new blank database.
11. Record a short presentation (2 to 3 minutes):
o Use Zoom to record a short presentation.
o Share your screen and have your webcam open so your face appears on the corner of the screen.
o In your presentation first open the ERDPlus website, login to your account, open the ER diagram
explain the main relationships in the ERD.
o Then, run MySQL workbench, and run the SQL scripts you have written to generate the tables.
12. In your report, write a short paragraph (max 250 words) to answer the following question: With regard to
respect for the human dignity, what measures have been considered in the design and implementation of
the Data Exchange? Is there any risk of disrespecting of human dignity in this database? If yes, how can
those risk be mitigated? Hint: Read section 4 of “Data Exchange Protocols” document (Protecting a
client’s personal information, page 11-15).
3
Structure
N/A
How do I submit?
Submit the following files via the submission link provided on LEO under Assessment section”
1. A Word document including the Feed Forward table (explained below), the ERD, and Relational Schema,
description of any assumptions you have made in designing the ERD, and a short explanation on what
measures have been considered to uphold human dignity in the design and implementation of the Data
Exchange.
2. A text file including the SQL scripts
3. A 2-3 minutes video presentation (mp4 format).
IMPORTANT NOTICE: Submissions that do not include the video presentation will NOT be marked.
Check your diagram before submission using the following checklist:
Self-Assessment Checklist
 Diagram uses correct E-R notation. The notation is used correctly for all elements of the diagram.
 The required number of tables and foreign key relationships will be needed to implement the database.
 Diagram presents a professional appearance. It could be shared with a “real-world” customer without
changes.
 Diagram captures all entity sets necessary for a database that would satisfy the initial problem statement
 Diagram captures all attributes and primary keys necessary for a database that would satisfy the initial
problem statement.
 Diagram captures all relationships necessary for a database that would satisfy the initial problem
statement.
 Diagram captures all cardinality and participation constraints necessary for a database that would satisfy
the initial problem statement
Feed Forward Template (example)
A template for students to use and act on feedback and provide recommendations for improvement.
Note
This is a task for any instance of follow-on assignment (assessment 2 and 3). This must be submitted as the first
page of the follow-on assignment (assessment 2 and 3) to ensure you acted on the feedback provided to you in the
previous assignment (this is not counted as part of the assessment word count).
How did you act on the feedback?
Feedback is an important component of learning. Please consider the feedback you received in your last
assignment and provide a response on how you acted on, or intend to act upon, that feedback, and how it has
informed the current assignment task. Submit this sheet along with your assignment.
Questions
Your learning from the previous assignment feedback
How have you acted on the feedback from
previous assignment to improve your work
in this assignment?
(e.g. based on my previous feedback, I made sure that I
supported my discussion, position, ideas, concepts with peer
reviewed journal references in this assignment)
4
What is your expectation around the type of
feedback that enhances your learning?
(e.g. I want to know where I made a mistake and how I can
correct them and not make the same mistake again i.e. I want
specific feedback that will help me to improve my learning and
performance in the next assignment)
Did you have any difficulty understanding
or acting on previous feedback? Please be
as specific as possible so that you can gain
further feedback/clarify anything you do not
understand in the feedback
(e.g. feedback provided in my previous assignment was very
generic I did not know how to improve my work. So, I would
like the teacher to explain more on xxxx aspects of the
feedback or I would like an opportunity to have a dialogue to
understand the feedback)
Some Helpful Websites and Resources
ERDPlus (https://erdplus.com)
Australian Department of Social Services: Data Exchange Protocols.
Who can help me?
Your lecturer and Lab tutor.
I’m having problems
Special Consideration: This form is used by students to apply for Special Consideration for assessable work in
studies at Australian Catholic University. Approval of such applications will only be granted to students who are
legitimately disadvantaged in their assessment due to exceptional and unforeseen circumstances beyond their
control.
Referencing
N/A.
Criteria
The full criteria are compiled in a rubric, which can be found on the following page/s.
5
Rubric for Assessment 1
Relevant
LO/GAs
Criterion (related to a
single GA from the related
LO – one GA per criterion
Does not meet
expectations
Meets
expectations
Exceeds expectations
NN
PA
CR
DI
HD
GA1
LO1
W: 5 marks
TL: 2
LS: I
Ability to recognise the
measure for protecting
human dignity in database
design the context of the
case study
No attempt or the
answer does not
address the topic.
Has identified some
of the measures for
protecting human
dignity
Has identified all
measures for
protecting human
dignity.
Has identified all
measures for
protecting human
dignity, and provided
an insightful
explanation of them.
Has identified all
measures for protecting
human dignity, provided
an insightful explanation
of them, and identified
further risks/solutions.
GA8
LO1
W: 20
marks
TL: 3
LS: I& D
Identification of information
requirements (Entities and
Attributes)
Representation of all logical
database design criteria
(notation, complexity,
professionalism, entity set,
attributes and keys,
relationships, constraints)
No attempt or less
than half of
required entities
attributes are
identified.
E-R notation or
uses a notation
incorrectly for most
elements.
Most of required
entities attributes
are identified
correctly.
Diagram uses
correct E-R
notation.
Most of required
entities attributes
are identified
correctly.
Diagram uses
correct E-R
notation.
Most Keys,
connectivity and
cardinalities are
correct.
Tables are in 2NF
most of required
entities attributes are
identified correctly
Most Keys,
connectivity and
cardinalities are
correct.
Tables are in 3NF
All required entities
attributes are identified
correctly
Nearly all Keys,
connectivity and
cardinalities are correct.
Tables are in 4NF
GA5
LO2
W: 5 marks
TL: 3
LS: I& D
Creation of a database based
on the conceptual design
No attempt or
created a blank
database
Database contains
all the correctly
identified entities,
of the case study.
Database contains
all the correctly
identified entities,
& properties of the
case study.
Database contains
all the correctly
identified entities,
properties & keys
of the case study.
Database contains all the
correctly identified
entities, properties,
keys, and relationships
of the case study.
6

READ ALSO...   MBAS903 Assessment 1
Order from Academic Writers Bay
Best Custom Essay Writing Services

QUALITY: 100% ORIGINAL PAPERNO PLAGIARISM – CUSTOM PAPER