Posted: February 1st, 2022

MIS602 Data Modelling & Database Design Assessment Two – Database programming evaluation practical

MIS602 Assign 3 Page 1 of 5
ASSESSMENT BRIEF
Subject Code and Title MIS602 Data Modelling & Database Design
Assessment Two – Database programming evaluation practical
Individual/Group Individual
Length See below for details
Learning Outcomes b, c
Submission Part 1: Thursday 11:59 PM AEST/AEDT of Module 4.2 (week 8)
Part 2: Sunday 11:59 PM AEST/AEDT of Module 4.2 (week 8)
Weighting 35%
Total Marks 35 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.
Instructions:
You are required to create the database tables as per the ERD below, and then generate
the SQL tasks listed in the table.
MIS602 Assign 3 Page 2 of 5
Note: The following tables give you an idea of what sample data looks like:
Movie
Movie_Id Movie_Name Released_Year Movie_Time Planned_Budget Director_Id Genre_Id
1001 Finding Nemo 2003 107 3.5 3002 2009
1002 The Incredibles 2004 116 0.5 3003 2009
1003 Beyond the Sea 2004 118 3 3007 2006
1004 Avatar 2009 116 10 3005 2008
Genre
Genre_Id Genre_Class
2001 Action
2002 Adventure
2003 Comedy
2007 Historical
3001 John Lasseter
3002 Pete Docter
3003 Andrew Stanton
3004 Brad Bird
3005 James Cameron
3006 Brenda Chapman
3007 Kevin Spacey
Task #
Task Description
Task 1 Create three tables with relevant keys as suggested in the above diagram and
the sample data tables.
Task 2 Insert 10 records to Movies table.
Task 3 Insert 5 records to Director table.
Task 4 Write a query to display all the information about the Movies.
Task 5 Write a query to display the Movie_Names of all the movies.
Task 6 Write a query to display all the Movie_Names and their Planned_Budget
Director
Director_Id Diector_Fname Director_Lname
2008 Science Fiction
2009 Animated
MIS602 Assign 3 Page 3 of 5
Task 7 Write a query to update the Movie_Time of ‘Finding Nemo’ to 120 minutes.
Make sure to insert some data that satisfy the criteria before executing the
query.
Task 9 Write a query to increase the planned budget of all Movies by 5% for all
the movies with a Planned_Budget less than 5 million.
Task 10 Write a query to display the all the details of the Movies directed by
Director_Id ‘3001’. Make sure to insert some data that satisfy the criteria
before executing the query.
the range of 100 – 200 minutes in Descending order.
Task 14 Write a query to count the total number of movies in the Movies table.
Task 15 Write a query to display the Director_Name and the total number of Movies
produced by each Director in ascending order.
Task 16 Write a query to delete the record of the Director whose firstvname is ‘James’
and last name is ‘Alex’. Make sure to insert some data that satisfy the criteria
before executing the query.
Task 17 Write a query to display all the movies written by Director “James
Cameroon”. Make sure to insert some data that satisfy the criteria before
executing the query.
Task 18 Write a query to display each Genre_Class and the total number of movies
belonging to each category.
Task 19 Write a query to display all the Movie Names with ‘Animated’ as the Genre.
Task 20 Write a query to display all the Movie Names and the first name of the
director who directed the movie in ascending order by Director_Fname.
Task 21 Write a query to display all the Genre_Class with no Movie name associated.
Task 22 Write a query to display the movies with minimum and maximum
Planned_Budget.
Task 23 Write a query to display all the Movie_Names and their director names.
Task 13 Write a query to display the list of all the Movie_Names with Movie_Time in
Task 8 Write a query to display the Movie_Id, Movie_Name of all the movies with a
planned budget above 3 million. Make sure to insert some data that satisfy
the criteria before executing the query.
Task 11 Write a query to display all the unique Director_Fname.
Task 12 Write a query to display Movie_Name, Movie Duration (Movie_Time) for all
movies released in 2001
MIS602 Assign 3 Page 4 of 5
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.
Task 24 Write a query to display the details of the movie including, the Movie Name,
Planned Budget, Movie Genre and the Director details.
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- a single zipped file for No. 1 and a Word processed file for No. 2 as
below.
1. SQL file (24 tasks) with outputs in a word document (.sql file plus .doc/.docx with output).
Learning Rubric: Assessment Three
Assessment
Attributes
Fail (Unacceptable)
0-49%
Pass
(Functional)
50-64%
Credit
(Proficient)
65-74%
Distinction
(Advanced)
75 -84%
High Distinction
(Exceptional)
85-100%
Understanding of the
SQL commands
30%
Demonstrates limited
understanding of SQL
commands
Fair understanding of SQL
commands demonstrated.
May neglect to provide
resources or that these are
cursorily provided without
reference to specific areas
in the source.
Good understanding of SQL
commands demonstrated.
May provide a limited
number of sources the peer
can use to develop their
technique from.
Very good understanding of
SQL commands
demonstrated. Makes
recommendations to other
external sources the peer
can access to develop their
understanding.
Outstanding understanding
of SQL commands
demonstrated through
recommendation of other
sources with specific
references to components
of it that the peer will
benefit from.
Completion of SQL
Statements for all Tasks
40%
Less than 50% Tasks are
completed
50-64% Tasks completed 65-74% essay writing Tasks completed 75-84% Tasks completed 85-100% Tasks completed
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.
MIS602 Assign 3 Page 5 of 5

Check Price Discount

More Assignment Samples: Assessment Task – NAPLAN Exercise – Word count: 500 words »