This exercise will be used as part of the Project: Build a Knowledge Engine. It is not optional. Several attempts based on my feedback will be necessary to complete it throughout the course.
WARNING: You will not be able to finish the projects in this course correctly if this document is not almost perfect! Below is a general path to a successful database creation project. Think of it as a snapshot of the rest of the course.
Produce a basic ERD (Entity Relationship Diagram)
Produce a NOMALIZATION Document
Use the NORMALIZATION Document as a guide to ffinalize the ERD
Use the ERD as a guide to create a DATA DEFINITION Document (using DDL – Data Definition Language)
Use the DATA DEFINITION Doc as a guide to produce ETL-SQL STATEMENT Document (Data Markup Language – DML) – DML is used to populate (fill) your tables with data, query your data, and update your data.
Use 1-5 to Build the Knowledge Engine (Database).
