MyAssignmenthelp
Get Help From World's No.1 Online Tutoring Company
Get Online Tutoring through WhatsApp
Call Now: (+61) 416-195-006
Get Online Tutoring through WhatsApp
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: |
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
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:
(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)
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.
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:
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).
Note: all non-submission or late submissions will be treated in accordance with the late assessment policy of the university.
Upon close analysis of the provided scenario in the introduction of the assignment, the library management system described required some necessary attributes to be associated with the data objects to make some operations to be carried out easily. These functions being, searching of the book collections – based on author name, book title and genre. Furthermore, the system would also be able to perform common functions such as add, delete or modifications of book details.
Want to contact us directly? No Problem. We are always here for you
Get Online
Online Tutoring Services