MIS602 Data Modelling & Database Design - Individual scenario based Assessment

Assessment One – Peer Assessment of File-based Database Design

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.

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.