Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Students also viewed these Databases questions