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.

Instructions:

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

Movie

GenreDirector

Submission Instructions

This assessment comprises of Part 1 and Part 2.

Part 1: This part is due on Week 8, Thursday 23:59 (Sydney time). It composes of the following two files, which must be submitted to Blackboard in a single zipped file.

1. SQL file (24 tasks) with outputs in a word document.
2. An Experience/Reflection report (Approximately 1000 words) in a word document summarizing your experience of doing this assignment.

Note: Following the submission of Part 1, you are also required to post the SQL file (Not experience report) onto the discussion forum. A thread has already been created in the discussion forum to post the SQL file, which you will be able to view on Week 8, Thursday 00:00 (Sydney time).

Part 2: This part is due on Week 8, Sunday 23:59 (Sydney time).

• From the pool of SQL files posted on the forum, you are required to write a short critique (Approximately 500 words) in a separate word document. Please DO NOT publish your critique onto discussion forum.
• Please note that your critique should provide constructive feedback highlighting the strengths and areas for improvement in the report. You should provide feedback on their usage of SQL commands and fulfil the following minimum requirements:
  1. Comment on the overall usage of SQL statements and commands used.
  2. Provide constructive criticism on how the author can improve their understanding of SQL statements.
  3. Provide some useful readings the author may pursue to help in developing the understanding of SQL statements.
• Submit the critique via Blackboard by following the same submission link as in Part 1.

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