Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Having problems with my sql schema. here is the schema script, having issues where the word visible Appears on line, 74, 87,100,113 -- MySQL Workbench

Having problems with my sql schema. here is the schema script, having issues where the word "visible" Appears on line, 74, 87,100,113

-- MySQL Workbench Forward Engineering

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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

-- ----------------------------------------------------- -- Schema mydb -- ----------------------------------------------------- -- ----------------------------------------------------- -- Schema mymovies -- -----------------------------------------------------

-- ----------------------------------------------------- -- Schema mymovies -- ----------------------------------------------------- CREATE SCHEMA IF NOT EXISTS `mymovies` DEFAULT CHARACTER SET latin1 ; USE `mymovies` ;

-- ----------------------------------------------------- -- Table `mymovies`.`tblactors` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mymovies`.`tblactors` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `First Name` VARCHAR(45) NOT NULL, `Last Name` VARCHAR(45) NOT NULL, `Gender` VARCHAR(45) NOT NULL, PRIMARY KEY (`id`)) ENGINE = MyISAM AUTO_INCREMENT = 42 DEFAULT CHARACTER SET = latin1;

-- ----------------------------------------------------- -- Table `mymovies`.`tbldirectors` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mymovies`.`tbldirectors` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `First Name` VARCHAR(45) NOT NULL, `Last Name` VARCHAR(45) NOT NULL, `Gender` VARCHAR(45) NOT NULL, PRIMARY KEY (`id`)) ENGINE = MyISAM AUTO_INCREMENT = 15 DEFAULT CHARACTER SET = latin1;

-- ----------------------------------------------------- -- Table `mymovies`.`tblgenre` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mymovies`.`tblgenre` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `Genre` VARCHAR(45) NOT NULL, PRIMARY KEY (`id`)) ENGINE = MyISAM AUTO_INCREMENT = 15 DEFAULT CHARACTER SET = latin1;

-- ----------------------------------------------------- -- Table `mymovies`.`tblmovies` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mymovies`.`tblmovies` ( `Film_Id` INT(11) NOT NULL, `Title` VARCHAR(45) NOT NULL, `DateOfRelease` DATE NOT NULL, `Genre` VARCHAR(45) NOT NULL, `Directors` VARCHAR(45) NOT NULL, `Rated` VARCHAR(45) NOT NULL, `Studio` VARCHAR(45) NOT NULL, `Format` VARCHAR(45) NOT NULL, `Running Time` VARCHAR(45) NOT NULL, PRIMARY KEY (`Film_Id`), UNIQUE INDEX `Film_Id_UNIQUE` (`Film_Id` ASC) VISIBLE) ENGINE = MyISAM AUTO_INCREMENT = 14 DEFAULT CHARACTER SET = latin1;

-- ----------------------------------------------------- -- Table `mymovies`.`movies_actors` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mymovies`.`movies_actors` ( `tblmovies_Film_Id` INT(11) NOT NULL, `tblactors_id` INT(11) NOT NULL, PRIMARY KEY (`tblmovies_Film_Id`, `tblactors_id`), INDEX `fk_tblmovies_has_tblactors_tblactors1_idx` (`tblactors_id` ASC) VISIBLE, INDEX `fk_tblmovies_has_tblactors_tblmovies_idx` (`tblmovies_Film_Id` ASC) VISIBLE) ENGINE = MyISAM DEFAULT CHARACTER SET = latin1;

-- ----------------------------------------------------- -- Table `mymovies`.`movies_directors` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mymovies`.`movies_directors` ( `tblmovies_Film_Id` INT(11) NOT NULL, `tbldirectors_id` INT(11) NOT NULL, PRIMARY KEY (`tblmovies_Film_Id`, `tbldirectors_id`), INDEX `fk_tblmovies_has_tbldirectors_tbldirectors1_idx` (`tbldirectors_id` ASC) VISIBLE, INDEX `fk_tblmovies_has_tbldirectors_tblmovies1_idx` (`tblmovies_Film_Id` ASC) VISIBLE) ENGINE = MyISAM DEFAULT CHARACTER SET = latin1;

-- ----------------------------------------------------- -- Table `mymovies`.`movies_genres` -- ----------------------------------------------------- CREATE TABLE IF NOT EXISTS `mymovies`.`movies_genres` ( `tblmovies_Film_Id` INT(11) NOT NULL, `tblgenre_id` INT(11) NOT NULL, PRIMARY KEY (`tblmovies_Film_Id`, `tblgenre_id`), INDEX `fk_tblmovies_has_tblgenre_tblgenre1_idx` (`tblgenre_id` ASC) VISIBLE, INDEX `fk_tblmovies_has_tblgenre_tblmovies1_idx` (`tblmovies_Film_Id` ASC) VISIBLE) ENGINE = MyISAM DEFAULT CHARACTER SET = latin1;

SET SQL_MODE=@OLD_SQL_MODE; SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS; SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases In Networked Information Systems 6th International Workshop Dnis 2010 Aizu Wakamatsu Japan March 2010 Proceedings Lncs 5999

Authors: Shinji Kikuchi ,Shelly Sachdeva ,Subhash Bhalla

2010th Edition

3642120377, 978-3642120374

More Books

Students also viewed these Databases questions

Question

5. What is all of this costing our organization/my department?

Answered: 1 week ago