Author: admin

According to the given data, violence against the person offences is found to be reducing in nature in 2010 as compared to the year 2009. However, violence against personal offences is segregated into two segments such as violence with injury and violence without injury. Overall reduction has been observed in the context of violence against personal offences. Hence, it can be concluded that the trend of the violence against personal offence is reducing nature
Attachments:
3072338_1_job-card.docx

Overview
The purpose of this task is to develop student’s skills in designing and implementing a relational
database for a given case study.
Timelines and Expectations
Percentage Value of Task: 20% (75 marks)
Due: Week 7 – Friday, May 3, 2019 at 4pm (16:00)
Minimum time expectation: Preparation for this task will take approximately 20 hours
Learning Outcomes Assessed
The following course learning outcomes are assessed by completing this assessment:
K4. Design a relational database for a provided scenario utilising tools and techniques including
ER diagrams, relation models and normalisation.
K5. Describe relational algebra and its relationship to Structured Query Language (SQL).
A1. Design and implement a relational database using a database management system.
Assessment Details
Background
You have been commissioned by Julie from ABC Event Organisers to design a database to assist them with managing
their booking, customer and supplier information. At this stage you have only been commissioned to provide the design
of the database.
ABC would like to store information regarding their customers. Customers may either be individual or corporate
customers. For individual customers they would like to store the contact name, address details (including their location,
postal and delivery address details), email address and phone numbers (mobile, home, work). For their corporate
customers they would like to store the business name, a contact name, address details (including their location, postal
and delivery address details), email address, website URL, and phone numbers (mobile, work).
ABC has a number of different suppliers who provide them with the products that they require to organise events. For
each supplier they would like to store their business name, contact name, address details (including their location,
postal and delivery address details), and phone numbers (mobile, work).
Each supplier may provide a number of different products. For example a supplier may provide furniture such as chairs,
tables, or other items such as table clothes, cutlery and crockery. Suppliers may only provide one product or many
different products. ABC would like to be able to search their database to obtain a list of suppliers who supply particular
products, however, they do not need to know how many of each particular product the supplier stocks.
In the database ABC would also like to store information about their staff. Staff may be employed full-time, part-time or
on a casual basis. ABC need to store contact information for the staff (address and phone), along with their TFN. They
ITECH 2004 DATA MODELLING
CRICOS Provider No. 00103D ITECH 2004 Assignment 1 Sem2 2019 Page 2 of 3
would also like to know what certifications the employees have. For example: “Responsible Serving of Alcohol”, “Food
Handling”, or any relevant police checks such as “Working with Children”. Each employee may hold a number of
different skills and certifications. Some staff are supervisors of other staff members and this also needs to be stored.
For each event ABC would like to store details such as where the event is to be held, the customer who they are
organising the event for, the date and time of the event, the type of event and how many people will be at the event.
ABC specialises in organising weddings, christenings, birthday parties and work functions. For each event they need to
store information about the supplies that they require (eg tables, chairs, cutlery), the supplier that they will be using for
the different products (they can use more than one), and how many of each product they require. ABC would also like
to store details of the staff that have been assigned to each event. Each event will have one staff member who takes
on the role of event manager.
Requirements
This assignment should be presented in a report format, including the following items:
• An ER Diagram with all entity names, attribute names, primary and foreign keys, relationships,
cardinality and participation indicated. All many to many relationships should be resolved.
• A discussion of normalisation, the normal form that each entity is in, how normalisation was
achieved, and why that is optimal. All entities to be in 3NF, unless there is strong justification
for leaving in 2NF.
• A list of relationships with all table names, attributes, primary and foreign keys indicated as
per the conventions given in the lecture slides (i.e. entity/table names in capitals, attributes as
proper nouns, primary key underlined and foreign keys in italics).
• A database schema indicating the type and purpose of all attributes.
Attachments:
3072348_1_itech-2004-ass-1-er-model-2019-05.pdf

Assignment 1 – Book Romance
Overview
This is an individual assignment in which you are required to develop a dynamic web application as
described below.
Important: This assignment specification is generated just for you. Do not distribute this specification.
Timelines and Expectations
Percentage value of task: 20%
Due: Refer to Course Description
Learning Outcomes Assessed
The following course learning outcomes are assessed by completing this assessment:
K3. Detect opportunities for increasing security and privacy of web applications
S1. Develop client/server web applications using client-side and server-side code
S2. Connect to and manipulate a database management system programmatically using server-side
code
A1. Design, develop, test, and debug client/server web applications to provided specifications
Assessment Details
For this assignment, you will create a web-based online dating system, vaguely similar to “Plenty of Fish” or
“Ok Cupid”.
Your platform is dedicated to matching up people with a shared interest in a certain topic – for your
assignment the topic is Book Romance, a place for book enthusiasts to meet.
Users can create accounts, indicate a set of books that they like, and find people to message who like
similar books.
You must implement this platform using PHP and MySQL or MariaDB, with some JavaScript for validation.
Database Structure
The web application uses a relational database. The database has the following structure:
User ( id, name, email, password, profile, photo_url )
Book ( id, title )
Likes (user_id, book_id)
Message (from_user_id, to_user_id, datetime, text)
Attachments:
3075025_1_ITECH3108-Assignment-1.pdf

You have recently been employed as a Business Analyst and your boss has decided to send you on a
short Enterprise Systems course. You have now returned from your course ad would like to demonstrate
your learning. Create an e-portfolio to provide a synopsis and reflection on your learning during
the course. You have been requested to document your learning in a portfolio that can be displayed on
your company’s intranet or knowledge portal. This way, the entire organization can access the document
and share in your newly acquired knowledge.
This assessment task will address the following ILOs:
• Evaluate and Integrate several information sources in analysing Enterprise Systems
• Describe the role of enterprise systems as part of the larger IT infrastructure of large scale organisations.
• Identify relevant considerations in the implementation of Enterprise Systems.
• Demonstrate communication skills to present a coordinated, coherent and independent exposition of knowledge
and ideas in dealing with Enterprise Systems.
Time allocation: Approximately 30-40 hours
Weighting: 30%
Submission: Using your student e-Portfolio account, create a link from Moodle to your Mahara page as
indicated on the submission link. You are required to prepare your responses to the assessment tasks as a
page in your Mahara e-Portfolio. (To be submitted in Week 11)
Referencing: Your portfolio should be a synthesis of ideas from a variety of sources expressed in your
own words. A minimum of 10 references is recommended. You should use the APA referencing style.
The University has published a style guide to help students correctly reference and cite information they
use in assignments (American Psychological Association (APA) citation style:
https://federation.edu.au/__data/assets/pdf_file/0020/313328/FEDUNI-GENERAL-GUIDE-TOREFERENCING-2016-EDITION_ed.pdf
Enterprise Systems
ePortfolio
Enterprise Systems Assessment Task
The Context
Intended Learning Outcomes (ILOs)
Assessment Guidelines
Marking Criteria: A passing grade will be awarded to assignments adequately addressing all
assessment criteria. Higher grades require better quality and more effort. For example, a minimum is set
on the wider reading required. A student reading vastly more than this minimum will be better prepared
to discuss the issues in depth and consequently their report is likely to be of a higher quality. So before
submitting, please read through the assessment criteria very carefully. Marking guides are provided.
Feedback: Feedback will be provided by the lecturer/tutor via Mahara, and mark via Moodle, no later
than 2 weeks from the submission date
Attachments:
3079364_1_Enterprise-Systems-Portfolio.pdf

Course Description
This course is the foundation course in Aboriginal Studies. It aims at promoting, from an historical
perspective, an understanding of Aboriginal people of modern Australia. It focuses on a broad range of
ideas including Aboriginal and European contact and the ensuing disruption of traditional culture,
interracial conflict and government legislation. The course provides an introduction to a number of current
issues affecting Aboriginal people, including health, education, law, business, cross-cultural relationships,
land rights and Aboriginal self-determination.
Course Learning Outcomes
At the completion of this course a student should be able to:
1. Describe the diversity of Aboriginal peoples (and Torres Strait Islanders) experience and culture.
2. Explain past and current issues affecting the lives of Aboriginal (and Torres Strait Islander) peoples.
3. Assess the quality of public debate about Indigenous policy.
4. Contribute respectfully to discussion and debate on key issues affecting the lives of Aboriginal (and
Torres Strait Islander) peoples.
Units of Credit 25 Delivery Mode Internal
Assumed Prior
Knowledge or
Special Skill
Requirements
Students without any prior knowledge of Aboriginal people or issues are welcome to
undertake this course. The course is designed to act as an introduction to contemporary
Indigenous Issues through understanding past events, actions, policies and impacts for
Aboriginal Australians. It also focuses on Indigenous and non-Indigenous actions aimed
at seeking social justice and self-determination.
Pre-requisite
Course/s Nil Co-requisite
Course/s Nil
Volume of Learning
Hours per semester
Class contact
39 hrs
Preparation for class
approx. 39 hrs
Assessments
approx. 72 hrs
Weekly Attendance
Lecture
ND4/101 11:00am – 12:30pm Monday Attend the weekly lecture
Tutorial
Please see the University Timetable or
the Blackboard site for this course for
the list of ABOR1000 tutorials.
Attend ONE weekly tutorial
STAFF DETAILS
Role Phone Email Office Availability
Course Coordinator
and Lecturer
Dr Christina Colegate
9433 0926
[email protected]
ND42/221 TBA
Tutor
Jenny Hunter TBA
[email protected]
TBA TBA
Tutor
Matthew Hughes TBA
[email protected]
TBA TBA
School of Arts and
Sciences Reception 9433 0100
[email protected]
ND42/215
Graduate Attributes & Professional Outcomes
Notre Dame’s Graduate Attributes are the generic qualities, skills and understandings which the
University aspires to develop in its students.
The student experience within the whole of this course – including classroom learning, engagement with
peers and staff, reading, preparation, assessment activities and reflection – should help students attain
the following (shaded) graduate attributes that Notre Dame aspires to:
Attachments:
3079746_1_ABOR1000-course-outline.pdf

ULO 1: Comprehend conceptual foundation for financial
decision-making in a typical business firm.
GLO1: Discipline specific knowledge
and capabilities
ULO 2: Evaluate risk-return trade-off in firm’s financial
decisions
GLO1: Discipline-specific knowledge
and capabilities
GLO4: Critical thinking
ULO 3: Apply relevant analytical techniques for
valuation of bond and share, short-term and long term
investment and financing decisions and working capital
management.
GLO1: Discipline-specific knowledge
and capabilities
GLO4: Critical thinking
GLO5: Problem Solving
Assessment Feedback:
Students who submit their work by the due date will receive their marks and feedback on
within 15 business days (University Policy)
Deakin’s Bachelor of Commerce and MBA are internationally EPAS accredited.
Deakin Business School is accredited by AACSB.
Page 2 of 9
Description / Requirements
a) The assignment has a weighting of 30% of your overall mark for the unit. The
assignment allocates 100 marks across the three parts I, II and III. Your group mark will be
converted to a score out of 30. All members of the group will receive the same mark.
b) If you are using an Excel spreadsheet for analysis, you need to explain which formula
you are using to work out the question, and copy and paste important output of the
spreadsheet to the body of your Word document. Alternatively, print out the narrative pages
(from Word doc) and the spreadsheets (from Excel file) and scan them into a single PDF which
can be uploaded. Please do not upload Excel spread sheets as a separate file.
Group Enrolments Instruction
a) The deadline for group registration is 11 May 2019 [AEST]. Late penalty will apply for
late registration. Please email Ms. Luna Lu (luna.lu@deakin.edu.au) if you didn’t enrol into a
group on time.
b) Please go to ‘Looking for group member’ discussion forum to initiate a discussion to
find group members, or students can discuss with fellow students in their classes/seminars.
It is highly recommended all group members exchange their names, student ID numbers,
and contact details (email addresses, mobile numbers, Facebook, twitter and etc.)
c) All students need to enrol in a group of 3 or 4 students to submit the assignment on
CloudDeakin. Individual group is not permitted generally and ONLY permitted in very unique
case, such as recommended by Learning Access Plan (LAP). You can form a group with any
student from any seminar group (On-Campus or Cloud). The only requirement is that all
members should be currently enrolled in MAF203 2019 Trimester 1.
d) Students can ONLY sign into any group after obtaining the consent from outstanding
members. Any uninvited student will be removed from the group upon outstanding
members’ written request to Unit Chair (sagarika.mishra@deakin.edu.au) or Ms. Luna Lu
(luna.lu@deakin.edu.au).
e) Group members should be responsible for maintaining continuous communication
among each other. If any student quits the unit during the trimester, please inform other
members about the decision by courtesy.
f) Marking, dispute resolution and free riders: the marking will be done for the group
as a whole, not on individual basis. In case of any dispute among the group members or if
there are any free riders identified in the group, all the members should report to the Unit
Chair in writing.
Page 3 of 9
Submission Instructions
a) Two files (Word document + Excel Document) should be uploaded for your group on
the MAF203 CloudDeakin site. List the names and ID numbers of all group members on the
first page of your Word document. Only one member of the group should submit the
assignment on CloudDeakin on behalf of all the group members. Assignments sent as e-mail
attachments or by mail will not be accepted under any circumstances.
ONE WORD file containing
• Title page: Group number, student name, student ID
• Body/content of the assignment:
Except Part II Question 1, all questions should be answered in order and presented
in Word Document (If you have managed to copy question 1 in the Word document,
you can leave it in)
With quantitative questions, please show your working out and answer clearly and
have a brief explanation of each answer.(i.e. What formula and excel function you
used. Screenshot of excel table/answer is allowed if needed)
With qualitative questions, please follow the stated word count. The word count
recommendation allows +/- 10% leeway. References: Harvard referencing style
• Executive Summary, Introduction and Conclusion is NOT required
ONE EXCEL file containing
• Part II question 1 answer
• The data and working out for all other questions if you are using Excel to work out those
questions
Please note that the marker may check the Excel file for further clarification; However, your
Word Document should contain all the working out and answer except Part II question 1
b) You must keep a backup copy of every assignment you submit, until the marked
assignment has been returned to you. In the unlikely event that one of your assignments is
misplaced, you will need to submit your backup copy.
c) Any work you submit may be checked by electronic or other means for the purposes
of detecting collusion and/or plagiarism.
d) When you are required to submit an assignment through your CloudDeakin unit site,
you will receive an email to your Deakin email address confirming that it has been submitted.
You should check that you can see your assignment in the Submissions view of the Assignment
dropbox folder after upload, and check for, and keep, the email receipt for the submission.
e) Extension of assignment submission has to be applied in writing and approved by Unit
Chair. Conditions under which an extension will be approved include:
f) Medical conditions of a serious nature, e.g. hospitalization, serious injury or chronic
illness. Note: Temporary minor ailments such as headaches, colds and minor gastric upsets
are not serious medical conditions and are unlikely to be accepted. However, serious cases of
these, with medical certificate, may be considered. ii) Compassionate e.g. death of close
family member, family breakdown. iii) Hardship/Trauma e.g. sudden loss or gain of
Page 4 of 9
employment, severe disruption to domestic arrangements, victim of crime. Note: late group
formation will not be accepted as grounds for extension.
Attachments:
3080838_1_MAF203-Asignment-T1-2019-update.pdf
3080838_2_WhatsApp-Image-2019-05-09-at-3.57.03-PM.jpeg
3080838_3_MAF203-Assignment-T1-2019-Part-II-data.xlsx