MIS602-Assessment-2-Database-programming-evaluation-practical (Part 1 and Part 2)

 Assessment 2: Database programming evaluation practical  

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:

You are required to create the database tables as per the ERD below, and then generate the SQL tasks given in the table.

Submission Requirements and Instructions

This assessment comprises of TWO parts. 

PART I 

Requirements: Complete all the SQL tasks given in the table above. After completing the SQL tasks, 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 7, Thursday 23:59 (Sydney time)

1. SQL file (24 tasks) with results and outputs in a word document.

2. Experience/Reflection report. 

Note: On the following day, you will receive another student’s assignment 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 assignment 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 usage of SQL statements and commands used.

· Provide constructive criticism on how the author can improve their understanding of SQL statements.

· Provide some useful readings the author may pursue to help in developing the SQL skills in the future. 

Submission: Your submission must composed of the following files, which must be submitted to Blackboard in a single zipped file on or before Week 7, Sunday 23:59 (Sydney time)

1. Critique of 500 words.

2. The author’s report, which your critique was based upon.