Need help on MySQL assignment. If you can please complete the questions and code needed for DBM 449 ilab 6. Page

11 is the report with all the questions and codes needed to complete the assignment are on the attached file. Any Questions please ask.  ATTACHMENT PREVIEW Download attachmentLaboratory ProceduresDeVry UniversityCollege of Engineering and Information SciencesI.OBJECTIVES1.Understand and become familiar with the SQL Analytical Extensions.2.Learn to create, use, and maintain materialized views, and their functional equivalents.3.Effectively apply Advanced Aggregate SQL Operations, such as GROUP BY ROLLUP tosolve business intelligence questions and analytical processing problems.II.PARTS LIST1.EDUPE-VT Omnymbus Virtual Machine Environment (https://devry.edupe.net:9090/)and/or:2.MySQL (dev.mysql.com/downloads)III.PROCEDUREScenario and SummaryFor the lab this week, we are going to look at how the ROLLUP and CUBE extensions availablein SQL can be used to create query result sets that have more than one dimension to them. Bothof these extensions are used in conjunction with the GROUP BY clause and allow for a muchbroader look at the data.To record your work for this lab use the lab report found at the end of this document. As in yourprevious labs, you will need to copy/paste your SQL statements and results into this document.Upon completion and prior to the due date, submit this document to the appropriate Dropbox.iLAB STEPSSTEP 1: Setting UpFor this lab you will be using a different user and set of tables than you have used so far for otherlabs. To set up your instance you will need to do the following.The first thing you will do for this lab is to run the following SQL Script. Begin by creating theDBM449Lab6 Schema, and creating any user accounts and privileges you wish to use (at leastone).Run the following script to create and populate a set of tables that will be used for this lab.Instructions for this are outlined in Step 1.SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,FOREIGN_KEY_CHECKS=0;SET @OLD_SQL_MODE=@@SQL_MODE,SQL_MODE=’TRADITIONAL,ALLOW_INVALID_DATES’;USE `DBM449Lab6` ;

View the Answer— ——————————————————- Table `DBM449Lab6`.`DISTRICT`– —————————————————–DROP TABLE IF EXISTS `DBM449Lab6`.`DISTRICT` ;CREATE TABLE IF NOT EXISTS `DBM449Lab6`.`DISTRICT` (`DIST_ID` INT(11) NOT NULL,`DIST_NAME` VARCHAR(10) NULL DEFAULT NULL,PRIMARY KEY (`DIST_ID`))ENGINE = InnoDB;– ——————————————————- Table `DBM449Lab6`.`CUSTOMER`– —————————————————–DROP TABLE IF EXISTS `DBM449Lab6`.`CUSTOMER` ;CREATE TABLE IF NOT EXISTS `DBM449Lab6`.`CUSTOMER` (`CUST_CODE` DECIMAL(10,0) NOT NULL,`CUST_LNAME` VARCHAR(15) NULL DEFAULT NULL,`CUST_FNAME` VARCHAR(15) NULL DEFAULT NULL,`CUST_INITIAL` CHAR(1) NULL DEFAULT NULL,`CUST_STATE` CHAR(2) NULL DEFAULT NULL,`DIST_ID` INT(11) NOT NULL,PRIMARY KEY (`CUST_CODE`),CONSTRAINT `fk_CUSTOMER_DISTRICT1`FOREIGN KEY (`DIST_ID`)REFERENCES `DBM449Lab6`.`DISTRICT` (`DIST_ID`)ON DELETE NO ACTIONON UPDATE NO ACTION)ENGINE = InnoDB;CREATE INDEX `fk_CUSTOMER_DISTRICT1_idx` ON`DBM449Lab6`.`CUSTOMER` (`DIST_ID` ASC);– ——————————————————- Table `DBM449Lab6`.`SUPPLIER`– —————————————————–DROP TABLE IF EXISTS `DBM449Lab6`.`SUPPLIER` ;CREATE TABLE IF NOT EXISTS `DBM449Lab6`.`SUPPLIER` (`SUP_CODE` INT(11) NOT NULL,`SUP_NAME` VARCHAR(35) NULL DEFAULT NULL,`SUP_AREACODE` CHAR(3) NULL DEFAULT NULL,`SUP_STATE` CHAR(2) NULL DEFAULT NULL,PRIMARY KEY (`SUP_CODE`))

Show

Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"