Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Requirements Given this dataset: 1. Create a normalized ER diagram for this data in MySqI Workbench. a. Take and save a screenshot of the completed
Requirements Given this dataset: 1. Create a normalized ER diagram for this data in MySqI Workbench. a. Take and save a screenshot of the completed ER diagram 2. After you are finished creating the ER diagram, use Workbench's Forward Engineering option to create a SQL script from the ER diagram. 3. Once you have completed creating the script, run the script to create a database with tables and relations in MySQL. 4. Use MySQL's CLI to: a. Output a list of the tables that exist in the database. b. Output the structure of each table. c. Take a screen shot of all of these outputs. Deliverables Copy the following items into a Word document. 1. The screen shot of the completed ER diagram in Workbench. 2. The script that was created by Forward Engineering the ER diagram in Workbench. 3. The MySQL's CLI screen shot of the list of tables in the database. 4. The MySQL's CLI screen shots of the structures of all of the tables in the database. Reference https://www.kaggle.com/shivambetflix-shows\#netflix_titles_nov_2019.csv
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started