Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

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...

1 answer below »

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
Answered Same Day Dec 08, 2021

Solution

Shikha answered on Dec 09 2021
153 Votes
Version 1
    Student Table                            Courses Enrolled                        FacilitatorCourse
    StudentID    StudentName    Semester    Age    Gender    City        EnrollmentID    CourseID    StudentID    EnrollDate    STATUS        FacilitatorID    CourseID    StaffID    StartDate    EndDate    STATUS
    S001    Anita    2    23    MALE    Sydney        E001    CSC    S001    10/07/19    1        F001    CSC    St001    01/01/19    31/12/19    0
    S002    John    1    29    MALE    Melbourne        E002    ELC    S002    6/10/19    1        F002    ELC    St002    12/03/19    21/11/19    1
    S003    Mikael    3    19    FEMALE    Brisbane        E003    CSC    S003    10/8/19    0        F003    CSC    St003    21/05/19    15/12/19    1
    S004    Mechael    4    28    MALE    Perth        E004    AI    S004    8/10/19    1        F004    AI    St004    16/04/19    31/10/19    0
    S005    Jackson    3    24    FEMALE    Adelaide        E005    MLA    S005    03/06/19    3        F005    MLA    St005    01/04/19    31/03/19    2
    S006    Satyam    3    22    FEMALE    Gold Coast        E006    BTEC    S006    01/08/19    2        F006    BTEC    St006    31/04/19    01/12/19    0
    S007    Varun    4    25    MALE    CANBERRA        E007    BSC    S007    05/09/19    1        F007    BSC    St007    01/02/19    23/12/19    1
    S008    Rahul    1    21    MALE    Newcastle        E008    SCI    S008    23/09/19    0        F008    SCI    St008    25/03/19    31/11/19    0
    S009    Anjali    2    23    FEMALE    Logan City        E009    MATHS    S009    13/04/19    1        F009    MATHS    St009    11/10/19    03/06/20    3
    S0010    Josph    3    25    MALE    Geelong        E0010    SC    S0010    05/09/19    2        F010    SC    St0010    01/02/19    03/10/19    1
    S0011    Nick    1    22    MALE    Sydney
    S0012    Anderson    2    23    MALE    Melbourne
    S0013    William    3    24    MALE    Brisbane
    S0014    Sanjana    4    25    FEMALE    Perth
    S0015    Ba
ara    5    26    FEMALE    Adelaide
    S0016    Caliconia    1    22    FEMALE    Gold Coast
    S0017    Diana    2    23    FEMALE    CANBERRA
    S0018    Daisy    3    24    FEMALE    Newcastle
    S0019    Enders    4    25    MALE    Logan City
    S0020    Flaun    5    26    MALE    Geelong
    S0021    George    6    26    MALE    Melbourne
    S0022    Rustam    1    22    MALE    Brisbane
    S0023    Naaina    2    23    FEMALE    Perth
    S0024    Shikha    3    24    FEMALE    Adelaide
                                                            Course Facilitated...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here