Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Power Bi And Azure Integrating Cloud Analytics For Scalable Solutions

Authors: Kiet Huynh

1st Edition

B0CMHKB85L, 979-8868959943

More Books

Students also viewed these Databases questions

Question

Explain Coulomb's law with an example

Answered: 1 week ago

Question

What is operating system?

Answered: 1 week ago

Question

What is Ohm's law and also tell about Snell's law?

Answered: 1 week ago