DEFS.4.4.Course Assignment - sj50179/IBM-Data-Science-Professional-Certificate GitHub Wiki

This module contains the final project for this course. You will consolidate the skills that you learned throughout this course by applying them to a specific scenario. To complete the project successfully, you must demonstrate that you have the skills to design a database from a new set of data, including creating an ERD to identify entities, attributes, and relationships. You will normalize tables, create your database, and load some data. You will also demonstrate some database management tasks by working with views.

Learning Objectives

  • Create an ERD of a database.
  • Generate and execute an SQL script from an ERD to create a schema.
  • Load the database schema with data.