Microsoft Word - MIS602-Assign1-v.1.1.docx
MIS602 Assign1 Page 1 of 3
ASSESSMENT BRIEF
Subject Code and Name MIS602 Data Modelling & Database Design
Assessment One – Peer Assessment of File-based Database Design
Individual/Group Individual
Length See below for details
Learning Outcomes B
Submission Thursday 11:59 PM AEST/AEDT of Module 2 (week 4)
Sunday 11:59 PM AEST/AEDT of Module 2 (week 4)
Weighting 25%
Total Marks 25 marks
Context:
The MIS602 Data Modelling & Database Design subject is designed for you to progressively add to
your understanding of data and database management and its relevance with in business context. It
also introduces you to some of the key features of database management system and designing
database systems that will feature in later modules of this topic. In order for you to do well in this
subject, it is imperative that you undertake all of the learning activities in the modules. The learning
activities are presented as a way of scaffolding your learning so that you can attempt the building
locks of the assessments and be in a safe environment to fail and to learn from them. Therefore,
doing your learning activities and seeking feedback from them from peers and from the learning
facilitator is the single best way of preparing for doing well in this assessment.
Instructions:
There is an imperative requirement in this assessment; you must submit different versions of the
files by Thursday of week 4 at midnight (Sydney time). The files should ideally be of excel format.
The data in the files should be composed based on the following scenario:
To
ens University Australia (TUA) is interested in a new Student record management
system. This system needs a database to manage students enrolled, courses students
enrolled in and staff facilitating the course. You will need to store and manage the data for
the enrolled students, courses and the staff assigned to the courses. The system is intended
to be built in-house. The university has a very strong information systems suite of programs
and the students of that program are showing great insight and promise. It has signalled its
intention to seek input from those students in a consulting a
angement.
MIS602 Assign1 Page 2 of 3
The system should allow the staff to add, update and delete the records of students, staff
allocated to course and courses. In addition, University staff should be able to see the list of
students enrolled in a particular course facilitated by a particular learning facilitator.
Based on this scenario, you should identify key data objects and their attributes and define them as
columns in the spreadsheet. Create multiple versions of the spreadsheet file as per below
instruction:
• Version 1 (V1.0) with all possible database objects and attributes and create 30 rows of data.
• Version 2 (V1.1) of the file should update last 2 records and add 5 additional records
• Version 3 (V1.2) of the file should add 2 new attributes
• Version 4 (V1.3) of the file should remove 5 existing attribute and add 5 more rows of data
When you are finished this, combine the four versions of the Excel database solution with a
document that in more than 1000 words, describing your experience. On the morning following
submission, the learning facilitator will allocate you another student’s spreadsheets and summary
document to assess. It is then your turn to assess another student’s work. You will have three days
to assess the other student’s work and to upload your response to Blackboard.
In no more than 500 words, provide a critique of that student’s work to them. You can choose
whether to identify yourself but you should provide constructive feedback, balancing good points
and points where the student can improve. You should use the scenario and provide feedback to
the other student on their list of data objects, data attributes and summary document. You are free
to use whatever framework you like and the following should be minimum inclusions:
• Comment on the overall suitability of the data objects and attributes as an input for
database design and the summary document
• Provide constructive criticism on how the other student can improve their data objects and
attributes in future
• Provide some useful readings the other student may peruse that helps them develop their
understanding of data and data attributes
Submission Instructions:
Your spreadsheets and summary should be submitted by Thursday at midnight (Sydney time) of
week 4. Do not include any identifying information on your submission (i.e. not your student
number, name or anything else that might identify you). This is important because the peer review
is to be done anonymously. Non-submission or lateness will be treated in accordance with the late
assessment policy of the university.
Please note that late submissions mean that another student will effectively have less time to do
their peer assessment of your work.
MIS602 Assign XXXXXXXXXXPage 3 of 3
Learning Ru
ic: Assessment One
Assessment Criteria
Fail
(Unacceptable)
0-49%
Pass
(Functional)
50-64%
Credit
(Proficient)
65-74%
Distinction
(Advanced)
75 -84%
High Distinction
(Exceptional)
85-100%
Understanding of the
Data and Data
attributes
30%
Demonstrates limited
understanding of Data
and Data attributes.
Fair understanding of Data
and Data attributes
demonstrated. May
neglect to provide
esources or that these are
cursorily provided without
eference to specific areas
in the source.
Good understanding of
Data and Data attributes
demonstrated. May
provide a limited
number of sources the
peer can use to develop
their technique from.
Very good understanding of
Data and Data attributes
demonstrated. Makes
ecommendations to other
external sources the peer can
access to develop their
understanding.
Outstanding understanding of
Data and Data attributes
demonstrated through
ecommendation of other
sources with specific
eferences to components of
it that the peer will benefit
from.
Application and
Evaluation of the File
ased database
management system
40%
Limited understanding of
the database
management system and
its applicability to
organization.
Understands the context
and impact the database
management system in an
organization and provides a
critique for the peer.
Understands the context
and impact the database
management system in
an organization.
Identifies logical flows
and questions the
viewpoints of the peer.
Evaluates the database
management system,
providing a critique of the
peer’s work, relevant to the
scenario. Identifies logical
flows and presents
suggestions the peer can use
to develop their technique.
Expertly evaluates the
database management
system presented by the peer.
Provides a thoughtful critique
in the context of the scenario
that the peer can use and
genuinely develop from.
Effective
communication
30%
Difficult to understand for
audience, no logical/clear
structure, poor flow of
ideas, argument lacks
supporting evidence.
Audience cannot follow
the line of reasoning.
Information, arguments and
evidence are presented in a
way that is not always clear
and logical. Line of
easoning is often difficult
to follow.
Information, arguments
and evidence are well
presented, mostly clear
flow of ideas and
arguments. Line of
easoning is easy to
follow.
Information, arguments and
evidence are very well
presented; the presentation is
logical, clear and well
supported by evidence.
Demonstrates cultural
sensitivity.
Expertly presented; the
presentation is logical,
persuasive, and well
supported by evidence,
demonstrating a clear flow of
ideas and arguments. Engages
and sustains audience’s
interest in the topic,
demonstrates high levels of
cultural sensitivity.
Sheet1
Student Table Courses Enrolled Course Facilitated BY
STUDENT_ID STUDENT_NAME SEMISTER AGE GENDER CITY ENROLL_ID COURSE_ID STUDENT_ID ENROLL_DATE STATUS FACILITATE_ID COURSE_ID STAFF_ID START_DATE END_DATE CREATED_AT STATUS
stu0001 JOHN 2 23 MALE Sydney enr_0001 CS_001 st0003 10/07/19 1 fac_0001 CS_001 AP_005 01/01/19 31/12/19 XXXXXXXXXX 0
stu0002 MIKE 1 29 MALE Melbourne enr_0002 EC_003 st0010 6/10/19 1 fac_0002 PS_123 DR_001 12/03/19 21/11/19 XXXXXXXXXX 1
stu0003 ANNA 3 19 FEMALE Brisbane enr_0003 CS_002 st0003 10/8/19 0 fac_0003 ML_003 AAP_003 21/05/19 15/12/19 XXXXXXXXXX 1
stu0004 JORDAN 4 28 MALE Perth enr_0004 AI_013 st0005 8/10/19 1 fac_0004 EM_011 SP_123 16/04/19 31/10/19 XXXXXXXXXX 0
stu0005 JILLIAN 3 24 FEMALE Adelaide enr_0005 ML_003 st0008 03/06/19 3 fac_0005 AD_003 JP_019 01/04/19 31/03/19 XXXXXXXXXX 2
stu0006 SHARLEN 3 22 FEMALE Gold Coast enr_0006 AA_001 st0001 01/08/19 2 fac_0006 EC_003 TP_123 31/04/19 01/12/19 XXXXXXXXXX 0
stu0007 WILLIAM 4 25 MALE CANBERRA enr_0007 DL_007 st0007 05/09/19 1 fac_0007 CS_002 CAP_112 01/02/19 23/12/19 XXXXXXXXXX 1
stu0008 Steven 1 21 MALE Newcastle enr_0008 EM_011 st0004 23/09/19 0 fac_0008 AI_013 JP_032 25/03/19 31/11/19 XXXXXXXXXX 0
stu0009 Edwards 2 23 FEMALE Logan City enr_0009 AD_003 st0010 13/04/19 1 fac_0009 AA_001 SP_213 11/10/19 03/06/20 XXXXXXXXXX 3
stu0010 Joseph 3 25 MALE Geelong enr_0010 PS_123 st0005 05/09/19 2 fac_0010 DL_007 DR_013 01/02/19 03/10/19 XXXXXXXXXX 1
Student Table Courses Enrolled Course Facilitated BY
STUDENT_ID STUDENT_NAME SEMISTER AGE GENDER CITY ENROLL_ID COURSE_ID STUDENT_ID ENROLL_DATE STATUS FACILITATE_ID COURSE_ID STAFF_ID START_DATE END_DATE CREATED_AT STATUS
stu0001 JOHN 2 23 MALE Sydney enr_0001 CS_001 st0003 10/07/19 1 fac_0001 CS_001 AP_005 01/01/19 31/12/19 XXXXXXXXXX 0
stu0002 MIKE 1 29 MALE Melbourne enr_0002 EC_003 st0010 6/10/19 1 fac_0002 PS_125 DR_001 12/03/19 21/11/19 XXXXXXXXXX 1
stu0003 ANNA 3 19 FEMALE Brisbane enr_0003 CS_002 st0003 10/8/19 0 fac_0003 ML_003 AAP_003 21/05/19 15/12/19 XXXXXXXXXX 1
stu0004 JORDAN 4 28 MALE Perth enr_0004 AI_013 st0005 8/10/19 1 fac_0004 EM_011 SP_123 16/04/19 31/10/19 XXXXXXXXXX 0
stu0005 JILLIAN 3 24 FEMALE Adelaide enr_0005 ML_003 st0008 03/06/19 3 fac_0005 AD_005 JP_019 01/04/19 31/03/19 XXXXXXXXXX 2
stu0006 SHARLEN 3 22 FEMALE Gold Coast enr_0006 AA_001 st0001 01/08/19 2 fac_0006 EC_003 TP_123 31/04/19 01/12/19 XXXXXXXXXX 0
stu0007 WILLIAM 4 25 MALE CANBERRA enr_0007 DL_007 st0007 05/09/19 1 fac_0007 CS_002 CAP_112 01/02/19 23/12/19 XXXXXXXXXX 1
stu0008 Steven 1 21 MALE Newcastle enr_0008 EM_011 st0004 23/09/19 0 fac_0008 AI_013 JP_032 25/03/19 31/11/19 XXXXXXXXXX 0
stu0009 Edwards Mamy 4 23 MALE Logan City enr_0009 AD_005 st0010 13/04/19 3 fac_0009 AA_001 SP_213 11/10/19 03/06/20 XXXXXXXXXX 3
stu0010 Joseph 2 23 MALE Geelong enr_0010 PS_135 st0007 05/09/19 2 fac_0010 DL_007 DR_013 01/02/19 03/10/19 XXXXXXXXXX 1
stu0011 ANNAMARI 3 26 FEMALE Sydney enr_0011 CS_002 st0011 09/10/19 2 fac_0011 PE_011 JP_099 05/05/19 06/09/19 XXXXXXXXXX 2
stu0012 MiCHEL 4 27 MALE Perth enr_0012 PE_011 st0012 03/07/19 0
updated Records
new Records
Student Table Courses Enrolled Course Facilitated BY
STUDENT_ID STUDENT_NAME SEMISTER AGE GENDER CITY isDeleted ENROLL_ID COURSE_ID STUDENT_ID ENROLL_DATE STATUS FACILITATE_ID COURSE_ID STAFF_ID START_DATE END_DATE CREATED_AT MODIFIED_AT STATUS
stu0001 JOHN 2 23 MALE Sydney 0 enr_0001 CS_001 st0003 10/07/19 1 fac_0001 CS_001 AP_005 01/01/19 31/12/19 XXXXXXXXXX XXXXXXXXXX 0
stu0002 MIKE 1 29 MALE Melbourne 0 enr_0002 EC_003 st0010 6/10/19 1 fac_0002 PS_125 DR_001 12/03/19 21/11/19 XXXXXXXXXX XXXXXXXXXX 1
stu0003 ANNA 3 19 FEMALE Brisbane 1 enr_0003 CS_002 st0003 10/8/19 0 fac_0003 ML_003 AAP_003 21/05/19 15/12/19 XXXXXXXXXX XXXXXXXXXX 1
stu0004 JORDAN 4 28 MALE Perth 0 enr_0004 AI_013 st0005 8/10/19 1 fac_0004 EM_011 SP_123 16/04/19 31/10/19 XXXXXXXXXX XXXXXXXXXX 0
stu0005 JILLIAN 3 24 FEMALE Adelaide 0 enr_0005 ML_003 st0008 03/06/19 3 fac_0005 AD_005 JP_019 01/04/19 31/03/19 XXXXXXXXXX XXXXXXXXXX 2
stu0006 SHARLEN 3 22 FEMALE Gold Coast 1 enr_0006 AA_001 st0001 01/08/19 2 fac_0006 EC_003 TP_123 31/04/19 01/12/19 XXXXXXXXXX XXXXXXXXXX 0
stu0007 WILLIAM 4 25 MALE CANBERRA 0 enr_0007 DL_007 st0007 05/09/19 1 fac_0007 CS_002 CAP_112 01/02/19 23/12/19 XXXXXXXXXX XXXXXXXXXX 1
stu0008 Steven 1 21 MALE Newcastle 0 enr_0008 EM_011 st0004 23/09/19 0 fac_0008 AI_013 JP_032 25/03/19 31/11/19 XXXXXXXXXX XXXXXXXXXX 0
stu0009 Edwards Mamy 4 23 MALE Logan City 1 enr_0009 AD_005 st0010 13/04/19 3 fac_0009 AA_001 SP_213 11/10/19 03/06/20 XXXXXXXXXX XXXXXXXXXX 3
stu0010 Joseph 2 23 MALE Geelong 0 enr_0010 PS_135 st0007 05/09/19 2 fac_0010 DL_007 DR_013 01/02/19 03/10/19 XXXXXXXXXX XXXXXXXXXX 1
stu0011 ANNAMARI 3 26 FEMALE Sydney 0 enr_0011 CS_002 st0011 09/10/19 2 fac_0011 PE_011 JP_099 05/05/19 06/09/19 XXXXXXXXXX XXXXXXXXXX 2
stu0012 MiCHEL 4 27 MALE Perth 1 enr_0012 PE_011 st0012 03/07/19 0
New Attribute
Student Table Courses Enrolled Course Facilitated BY
STUDENT_ID STUDENT_NAME SEMISTER AGE GENDER CITY isDeleted ENROLL_ID COURSE_ID STUDENT_ID ENROLL_DATE STATUS FACILITATE_ID COURSE_ID STAFF_ID START_DATE END_DATE CREATED_AT MODIFIED_AT STATUS
stu0001 JOHN 2 23 MALE Sydney 0 enr_0001 CS_001 st0003 10/07/19 1 fac_0001 CS_001 AP_005 01/01/19 31/12/19 XXXXXXXXXX XXXXXXXXXX 0
stu0002 MIKE 1 29 MALE Melbourne 0 enr_0002 EC_003 st0010 6/10/19 1 fac_0002 PS_125 DR_001 12/03/19 21/11/19 XXXXXXXXXX XXXXXXXXXX 1
stu0003 ANNA 3 19 FEMALE Brisbane 1 enr_0003 CS_002 st0003 10/8/19 0 fac_0003 ML_003 AAP_003 21/05/19 15/12/19 XXXXXXXXXX XXXXXXXXXX 1
stu0004 JORDAN 4 28 MALE Perth 0 enr_0004 AI_013 st0005 8/10/19 1 fac_0004 EM_011 SP_123 16/04/19 31/10/19 XXXXXXXXXX XXXXXXXXXX 0
stu0005 JILLIAN 3 24 FEMALE Adelaide 0 enr_0005 ML_003 st0008 03/06/19 3 fac_0005 AD_005 JP_019 01/04/19 31/03/19 XXXXXXXXXX XXXXXXXXXX 2
stu0006 SHARLEN 3 22 FEMALE Gold Coast 1 enr_0006 AA_001 st0001 01/08/19 2 fac_0006 EC_003 TP_123 31/04/19 01/12/19 XXXXXXXXXX XXXXXXXXXX 0
stu0007 WILLIAM 4 25 MALE CANBERRA 0 enr_0007 DL_007 st0007 05/09/19 1 fac_0007 CS_002 CAP_112 01/02/19 23/12/19 XXXXXXXXXX XXXXXXXXXX 1
stu0008 Steven 1 21 MALE Newcastle 0 enr_0008 EM_011 st0004 23/09/19 0 fac_0008 AI_013 JP_032 25/03/19 31/11/19 XXXXXXXXXX XXXXXXXXXX 0
stu0009 Edwards Mamy 4 23 MALE Logan City 1 enr_0009 AD_005 st0010 13/04/19 3 fac_0009 AA_001 SP_213 11/10/19 03/06/20 XXXXXXXXXX XXXXXXXXXX 3
stu0010 Joseph 2 23 MALE Geelong 0 enr_0010 PS_135 st0007 05/09/19 2 fac_0010 DL_007 DR_013 01/02/19 03/10/19 XXXXXXXXXX XXXXXXXXXX 1
stu0011 ANNAMARI 3 26 FEMALE Sydney 0 enr_0011 CS_002 st0011 09/10/19 2 fac_0011 PE_011 JP_099 05/05/19 06/09/19 XXXXXXXXXX XXXXXXXXXX 2
stu0012 MiCHEL 4 27 MALE Perth 1 enr_0012 PE_011 st0012 03/07/19 0 fac_0012 PY_205 DR_!03 12/10/19 02/05/20 XXXXXXXXXX XXXXXXXXXX 1
stu0013 MOSH 2 23 MALE Adelaide 0 enr_0013 PS_100 st0014 05/10/19 1
stu0014 MAX 3 25 MALE Brisbane 0 enr_0014 PY_205 st0013 06/06/10 0
Deleted
New Rows
A properly designed database provides you with access to up-to-date, accurate information. Certain principles guide the database design process. The first principle is that duplicate information (also called redundant data) is bad, because it wastes space and increases the likelihood of e
ors and inconsistencies
A good database design is, therefore, one that:
1. Divides your information into subject-based tables to reduce redundant data.
2. Provides Access with the information it requires to join the information in the tables together as needed.
3. Helps support and ensure the accuracy and integrity of your information.
4. Accommodates your data processing and reporting needs.
The design process consists of the following steps:
· Determine the purpose of your database
· This helps prepare you for the remaining steps.
· Find and organize the information required
· Gather all of the types of information you might want to record in the database, such as product name and order number.
· Divide the information into tables
· Divide your information items into major entities or subjects, such as Products or Orders. Each subject then becomes a table.
· Turn information items into columns
· Decide what information you want to store in each table. Each item becomes a field, and is displayed as a column in the table. For example, an Employees table might include fields such as Last Name and Hire Date.
· Specify primary keys
· Choose each table’s primary key. The primary key is a column that is used to uniquely identify each row. An example might be Product ID or Order ID.
· Set up the table relationships
· Look at each table and decide how the data in one table is related to the data in other tables. Add fields to tables or create new tables