ITECH 2004 : Data Modelling - Structured Query Language - IT Computer Science Assignment Help

Assignment Task :

Learning Outcomes Assessed

The following course learning outcomes are assessed by completing this assessment:

K5. Describe relational algebra and its relationship to Structured Query Language (SQL).

S1. Interpret entity-relationship diagrams to implement a relational database.

S2. Demonstrate skills in designing and building a database application using a commercially available database management system development tool.

S3. Use a query language for data manipulation.

A1. Design and implement a relational database using a database management system.

Question 1. Write the SQL command to find the name and year of the movies that contain the word “the”.

Question 2. Write the SQL command to return the name of all genres and name of movies together in a single list.

Question3. Write the SQL command to aggregate sum the number of ratings and average number of stars per reviewer. 

Question 4. Write the SQL command to list the names of the actors who did not play a role in the movie Deliverance.  

Question 5. Write the SQL command to find the titles of all movies that have more than one reviewer.  

Question 6. Write the SQL command to find the movie title, and the total number of actors that appeared in that movie, and arrange the result according to the number of actors in descending order.  

Question 7. Write the SQL command to find the titles of all movies where the average stars rating is higher than 8.0 and the actor was  Christian Bale.  

This IT Computer Science Assignment has been solved by our IT Computer Science  Experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.