Question: creating a movie Db in mysql workbench. I reverse engineered so I could create my erd diagram. Now I am trying to forward engineer, but

creating a movie Db in mysql workbench. I reverse engineered so I could create my erd diagram. Now I am trying to forward engineer, but i keep getting this error message in my logs. ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VISIBLE, INDEX `fk_tblmovies_has_tbldirectors_tblmovies_idx` (`tblmovies_Film_' at line 7 SQL Code: -- ----------------------------------------------------- -- 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, INDEX `fk_tblmovies_has_tbldirectors_tbldirectors1_idx` (`tbldirectors_id` ASC) VISIBLE, INDEX `fk_tblmovies_has_tbldirectors_tblmovies_idx` (`tblmovies_Film_Id` ASC) VISIBLE, PRIMARY KEY (`tblmovies_Film_Id`, `tbldirectors_id`)) ENGINE = MyISAM DEFAULT CHARACTER SET = latin1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

Creating a simple database Java Most of this lab has been written for you, with comments. Read over the code and the comments carefully, so that you understand what is being done. Note especially,...

Modify and enhance a Database Project. Movies Table: Column Name Data Type Constraints movie_id INT PRIMARY KEY title VARCHAR NOT NULL release_year INT NOT NULL runtime INT NOT NULL rating VARCHAR...

For C++ Programing Overview For this assignment, you will be creating a simple movie database. You will populate your database by reading in information from a file whose name will be entered by the...

will rate highly! need help with these three of the cus. This is where www This will now ITO y Dear Band When the Aromat So they They were DowPV7900 you by chowy wire. The ich by Lancome 1.00 Dow...

Suppose that Disney is considering one more Toy Story movie. The company is not confident in box office sales, but they do believe that the file will create merchandising opportunities (DVDs, toys,...

Do the instructions for the following graphic from Halpin. Create your own word doc, and submit to canvas. Model this using ORM Scenario: You are to model a movie db, very simple! Below is a table...

In C++ please. if anyone can do their best. It would be greatly appreciated! Thank You! With file as well. Create a simple movie database. You will populate your database by reading in information...

In C++ please. I understand it's a long question so if anyone can do their best. Greatly appreciated. Create a simple movie database. You will populate your database by reading in information from a...

Below is how to solve a similar problem but i cant seem to get the right answer for the problem above so please help Suppose that Disney is considering one more Toy Story movie. The company is not...

You find two properties that have sold twice within the last two years. Property A sold 23 months ago for $228,375; it sold last week for $274,000. Property B sold 6months ago for $187,310; it sold...

An alternative proof of Theorem 3 based on the generalized pigeonhole principle is outlined in this exercise. The notation used is the same as that used in the proof in the text. a) Assume that ik n...

The purchase of Corn options contracts does not require the buyer to post margin money with a broker. True False Clear selection Question 3 6 Question 3 6 2 . 5 Points Question 3 6 The seller of a...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Developing and delivering learning that is integrated with the job.

Use of assessments to determine trainees learning styles.

7. Discuss the advantages of embedded learning.