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

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 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 Summary of the campaign for each game o Number of game and series for each production studio o Most popular promotion channel o Other 7 useful query
May 16, 2020
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here