Assignment 1, MIS201 XXXXXXXXXXPage 1 of 5
ASSESSMENT 1 BRIEF
Subject Code and Title MIS201 Database Fundamentals
Assessment Case study
Individual/Group Individual
Length Task 1, 3 & 4: Models and Tables
Task 2: 600 words (+/- 10%)
Learning Outcomes The Subject Learning Outcomes demonstrated by successful
completion of the task below include:
a) Analyse specific organisational needs that can be addressed by
collection, storage and management of organisational data
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 25%
Total Marks 100 marks
Task Summary
Based on the case scenario provided, (1) developing a collection of spreadsheets on a file system to
manage a business process, (2) identifying and discussing the problems of using a collection of
spreadsheets on a file system, (3) discussing the benefits of using a database system and (4) drawing
an ERD and developing a database table design for the information system proposed in the case.
Context
This assessment aims to develop your understanding of the challenges involved in collecting, storing
and managing data in an organisational context. It assesses your ability to effectively identify the
enefits of a database system as well as your ability to build data models to simplify complex subject
matters.
Task Instructions
1. Please read the attached MIS201_Assessment 1_Case Scenario.
2. Based on the case scenario provided, please complete the following tasks:
Task 1 (10 marks)
Assignment 1, MIS201 XXXXXXXXXXPage 2 of 5
Design and create as many Microsoft Excel spreadsheets as you deem necessary to manage and store
academic misconduct cases as detailed in the case scenario. Note one Microsoft Excel file may
contain many spreadsheets.
Task 2 (50 marks)
A collection of spreadsheets created to manage the data are shared on network drive may
experience many problems. Identify and discuss the problems with examples related to the case
scenario with respect to data redundancy, data independence, data consistency, data integrity, data
security and the scale of data sharing.
Also, discuss whether — and if so how — a database system could solve most of the problems that
a collection of spreadsheets on a file system would encounter. Please note that your response to this
task should be 600 words +/-10%.
You do not need to use a Report format for your answer. Use headings (e.g. Data redundancy, Data
independence, Advantages of a database system) to structure your answer.
Task 3 (25 marks)
The University Management decides to develop an information system (the ‘System’) to address the
cases study scenario provided with this assignment. The System shall facilitate the management of
data requirements of the scenario provided in the case study, and shall allow easy generation of
eports to the stakeholders of various levels.
Draw an Entity Relationship Diagram (ERD) to model the data requirements of the system provided
in the case study.
Task 4 (15 marks)
Based on the ERD you completed in the previous task, design database tables for the System. Provide
the following information for each database table. Please note that ERD must be drawn using
LucidChart or an equivalent professional diagramming software package.
TABLE_NAME
COLUMN NAME PRIMARY KEY/FOREIGN KEY FORMAT SAMPLE DATA
For example,
Student
COLUMN NAME PRIMARY KEY/FOREIGN KEY FORMAT SAMPLE DATA
STUDID PRIMARY KEY AUTO-
INCREMENT
1
STUDENTCOURSE FOREIGN KEY STRING BBIS
DATEAPPLIED DATE 14/6/2021
Referencing
It is essential that you use appropriate APA style for citing and referencing research. Please see
more information on referencing in the Academic Skills webpage.
https:
li
ary.to
ens.edu.au/academicskills/apa/tool
Assignment 1, MIS201 XXXXXXXXXXPage 3 of 5
Submission Instructions
Please submit ONE MSWord document (.doc or .docx) compiling the tasks 2,3 and 4 and 1 excel file
(task1) 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
eferenced and academically written according to the Academic Writing Guide. Students also need
to have read and be aware of To
ens University Australia Academic Integrity Policy and Procedure
and subsequent penalties for academic misconduct. These are available at
https:
www.to
ens.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.
https:
www.to
ens.edu.au/policies-and-forms
https:
www.to
ens.edu.au/policies-and-forms
Assignment 1, MIS201 XXXXXXXXXXPage 4 of 5
Assessment Ru
ic
Marking Criteria
Fail
(Yet to achieve
minimum standard)
0-49%
Pass
(Functional)
50-64%
Credit
(Proficient)
65-74%
Distinction
(Advanced)
75-84%
High Distinction
(Exceptional)
85-100%
Task 1 (10%)
➢ Design and creation of Microsoft Excel spreadsheets
to manage and store data as detailed in the case
scenario.
Task 2 (50%)
➢ Identify and discuss the problems with examples
elated to the case scenario with respect to data
edundancy, independence, consistency, integrity,
security and the scale of data sharing
➢ Discuss whether — and if so how — a database
system could solve most of the problems that a
collection of spreadsheets on a file system would
encounter.
Task 3 (25%)
➢ Draw an Entity Relationship Diagram (ERD) to model
the data that would be used in the System given the
case scenario.
Task 4 (15%)
➢ Based on the ERD, design database tables for the
System.
Assignement 1, MIS201 XXXXXXXXXXPage 5 of 5
Fail
(Unacceptable)
0-49%
A Fail grade will be awarded if a student is unable to demonstrate satisfactory
academic performance in the subject or has failed to complete required
assessment points in accordance with the subject’s required assessment points.
Pass
(Functional)
50-64%
Pass is awarded for work showing a satisfactory achievement of all learning
outcomes and an adequate understanding of theory and application of skills. A
consistent academic referencing system is used and