Question
Requirements Given this dataset (Reference Below) : Create a normalized ER diagram for this data in MySql Workbench. Take and save a screenshot of the
Requirements
Given this dataset (Reference Below):
Create a normalized ER diagram for this data in MySql Workbench.
Take and save a screenshot of the completed ER diagram
After you are finished creating the ER diagram, use Workbenchs Forward Engineering option to create a SQL script from the ER diagram.
Once you have completed creating the script, run the script to create a database with tables and relations in MySQL.
Use MySQLs CLI to:
Output a list of the tables that exist in the database.
Output the structure of each table.
Take a screen shot of all of these outputs.
Deliverables
Copy the following items into a Word document.
The screen shot of the completed ER diagram in Workbench.
The script that was created by Forward Engineering the ER diagram in Workbench.
The MySQLs CLI screen shot of the list of tables in the database.
The MySQLs CLI screen shots of the structures of all of the tables in the database.
Reference
https://www.kaggle.com/shivamb/netflix-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