Database System Case Study - IT/Computer Science Assignment Help

Assignment Task

Task 
Your task is to implement your database design from Assignment 1, using SQL. You will be using the MySQL Query Browser program to complete this part of the assignment. 
Instructions 
Using various SQL commands that you have learned, perform the following SQL queries: ? CREATE all tables (don’t forget your keys) 
? INSERT all tuples of data 
After you have created all your tables and data, run SQL statements to perform the following: 
? DELETE one row of data from each table 
? UPDATE one row of data from each table 
? ALTER each table by adding a new attribute 
And also: 
? Prepare SELECT statement to display 
o The total number of TV series available on BitStream. 
o The total number of Movies available on BitStream. 
o List the genres available on BitStream. (distinct values). 
o How many movies are based on a real story? 
o How many TV series is based on a book? 
o List (any) 5 Comedy movies in alphabetical order. 
o List the names of 2 directors who received more than one award. o List the titles of 3 PG movies/TV series. 
o The top 10 most popular movies on BitStream based on peoples’ reviews o Which TV series has the highest number of seasons? display the total number of seasons as well. 
o Summary of all the TV series that are streamed in BitStream, display short synopsis, year released the name of the main actor/actress, the director and the number of seasons for each series. 
o Summary of all Movies that are streamed in BitStream, display short synopsis about the movie, year released, the name of the main 
actor/actress and the director for each movie. 
What to submit 
Submit your assignment by creating your database tables in your MySQL Query Browser account. You will also need to submit via Canvas a text file* with all the queries you have used. 

This IT/Computer Science Assignment has been solved by our IT/Computer Science Experts at My Uni Paper. 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.