Do You Need Help With Your MIS602 Data Modelling & Database Design Assignment Help?

 

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.

 

 7.jpg

 
 


note: The following tables give you an idea of what sample data looks like:


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

 

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 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 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.

Task 11

Write a query to display all the unique Director_Fname.

Task 12

Write a query to display Movie_Name, Movie_Duration for all movies released

in 2001.

Task 13

Write a query to display the list of all the Movie_Names with Movie_Time in

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 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 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.

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% 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.

 

 
 

 

Preserve your Top Grade with Online Assignment Help Service 24/7 Know More