My home work

MIS602 Assignment 1 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 Part 1: Thursday 11:59 PM AEST/AEDT of Module 2 (week 4)

Part 2: Sunday 11:59 PM AEST/AEDT of Module 2 (week 4)

Intensive class:

Thursday 11:59 PM AEST/AEDT of Module 2 (week 2)

Sunday 11:59 PM AEST/AEDT of Module 2 (week 2)

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

Introduction:

This assignment is based on the following scenario:

ABC library is a small community library in the northern suburbs of Adelaide. In the recent years, its collection

of books and the number of registered users have increased significantly facing difficulties in manually handling

MIS602 Assignment 1 Page 2 of 3

its main functions efficiently. To improve its services, the senior management of the library has considered a

computerized library management system.

The library has a rich collection of books with different genres such as fiction, biography, and history to name

a few. The main functions considered for computerizing include searching of book collection based on author

name, book title and genre. For this, the system should allow common functions including add, delete and

modification of book details. Similarly, the library also wants to keep records of all the transactions— book

issue and return. Finally, the system should allow the library staff to view all transactions and associated

borrowers (library members) for each transaction, transaction date and the library staff who handled each

transaction.

Submission Requirements and Instructions:

This assessment comprises of TWO parts.

PART I

Requirements: Based on this scenario, you should identify key business data objects and their attributes and

define them as columns in a spreadsheet using MS excel or similar software. For this you are required to create

multiple versions, ideally one file with 4 sheets with each sheet numbered with the version number, of the

spreadsheet file as per below instruction:

• Version 1 (V1.0): List all the data objects and their attributes as columns, and then add at least 10 rows

of data.

• Version 2 (V1.1): Update last 2 records (highlight in blue) and add 5 additional records (highlight in

yellow) to each data object identified.

• Version 3 (V1.2): Add 2 new attributes (highlight in red) to each data object identified.

• Version 4 (V1.3) : Remove 1 existing attribute from each data object and add 5 more rows of data

(highlight in green).

After completing the spreadsheet versions, you are required produce and experience/reflection report (1000

words) in a word document summarizing your experience of doing these tasks.

Submission: Your submission must composed of the following files, which must be submitted to Blackboard on

or before Week 4, Thursday 23:59 (Sydney time)

1. Spreadsheet file. 2. Experience/Reflection report (Approximately 1000 words) in a word document summarizing your

experience of doing this assignment.

Note: On the following day, you will receive another student’s spreadsheet via email to review, for which you

are required to write a short critique. This is explained in the following section.

MIS602 Assignment 1 Page 3 of 3

PART II

Requirements: Based on the spreadsheet you received, you are required to write a critique of approximately

500 words. Please note that your critique should provide constructive feedback highlighting the strengths

and areas for improvement in the report, as well as any new knowledge gained from evaluating the authors

report. You should provide feedback on overall design of the database, and fulfil the following minimum

requirements:

 Comment on the overall design of the database including the appropriateness of data objects and the attributes taken into consideration.

 Provide constructive criticism on how author could enhance the overall database design, data

objects and attributes.

 Provide at least 4 useful readings the author may peruse to enhance understanding of business

data objects and their characteristics.

Submission: Your submission must composed of the following file(s), which must be submitted to Blackboard

in a single zipped file on or before Week 4, Sunday 23:59 (Sydney time).

1. Critique of 500 words. 2. The author’s report, which your critique was based upon.

Note: all non-submission or late submissions will be treated in accordance with the late assessment policy of

the university.

Learning Rubric: 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 resources or that

these are cursorily provided

without reference 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 recommendations to other

external sources the peer can

access to develop their

understanding.

Outstanding understanding of

Data and Data attributes

demonstrated through

recommendation of other sources

with specific references to

components of it that the peer will

benefit from.

Application and Evaluation of the File based 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 reasoning is

often difficult to follow.

Information, arguments and

evidence are well presented,

mostly clear flow of ideas

and arguments. Line of

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