Assignment on database management systems

Assignment Help Business Management

Reference no: EM132839949

Database management systems

https://www.kaggle.com/shivamb/netflix-shows#netflix_titles_nov_2019.csv

Download and extract the following dataset: netflix_titles_nov_2019.csv.zip

Open the dataset in Excel and examine its contents. You will see multiple columns of data. It should be obvious that this dataset is not normalized.

Requirements

Given this dataset:

Make a normalized ER diagram for this data in MySql Workbench.
Take and save a screenshot of the completed ER diagram

A. After you are finished creating the ER diagram, use Workbench's Forward Engineering option to make a SQL script from the ER diagram.

B. Once you have completed creating the script, run the script to make a database with tables and relations in MySQL.

Use MySQL's 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.

Please Include your zip files and step by step on how to achieve this..

My co worker and I are trying to learn for work and this is complicated.

Reference no: EM132839949

Questions Cloud

Discuss the company approach to business-level strategy : Discuss the company's approach to its business-level strategy. Issues you could take into consideration here include:

ICT204 Project Management Assignment : ICT204 Project Management Assignment Help and Solution, King's Own Institute - Assessment Writing Service - PMBOK Case Study

Describe the social and emotional concerns in children : It is important for educators to be aware of the organizations that exist to support families of young children. There are federal, state, and locally supported

How much is the noncurrent liabilities of the company : As of December 31, 2020, How much is the gain or loss on extinguishment of the PNB loan? How much is the noncurrent liabilities of the Company?

Assignment on database management systems : Open the dataset in Excel and examine its contents. You will see multiple columns of data. It should be obvious that this dataset is not normalized.

How much was the total cash paid to the bondholder : Assuming instead of renegotiating, jimmy retired the bonds for P9,150,000 on December 31, 2020. How much was the total cash paid to the bondholder on this date?

Describe the benefits strategy of the people department : Compare and contrast compensation and benefits strategy of the "people department" of Southwest Airlines to overall strategies of two other airlines.

What are the major forms of business org : 1. Why most large businesses are organized as corporations?

Find the adjusted balance in Marawi books : Find the adjusted balance in Marawi's books related to the Home Office account and the Marawi Branch Account in the Home office books

User Account

All Pages