Relational Database Design

An Introduction to Data Modeling

What you'll learn

Explain what relational database is

Understand how to avoid problems that can happen when we store data in tables

Design a database model that meets business needs and avoid data storage problems

Prepare your data model for actual database construction.

Requirements

No prior database experience is required. This course is designed for the beginner.

Description

In this foundational course, we begin by teaching you the basics of relational databases and how they work.  You will then learn the process of data modeling–translating a set of business needs into a visual "entity relationship diagram" that can be used to create a database.  You won't actually create the database in this course–this is primarily about the data modeling process.   What is most valuable about this course is the way that it will teach you to translate business requirements into data models using hands-on projects!  We will work with two imaginary clients who will give us a set of business requirements.  We'll create diagrams to serve their needs and modify the diagrams as their business needs grow and change.  In short, you will learn data modeling skills by DOING data modeling.  An outline of the topics includes:1.  An Introduction to Relational Databases:Components of Relational DatabasesTablesPrimary and Foreign Keys2.  Proper Database DesignData Anomalies and Avoiding Redundant DataNormalization (First - Third Normal Forms)Over-Normalization3. Data ModelingEntity Relationship Diagrams:  Entities and AttributesEntity Relationships and CardinalityResolving Many-to-Many Relationships4.  Data Modeling Project 1:  Downtown FloralBuild the Initial Data Model Based on Business RequirementsUpdate Model Based on Business Changes (Several Rounds)4.  Data Modeling Project 2: Best Tech UBuild the Initial Data Model Based on Business RequirementsUpdate Model Based on Business Changes (Several Rounds)I look forward to guiding you through this course.  Don't be intimidated by the terminology.  We'll take this a step at a time and you'll do great!

Overview

Section 1: Introduction

Lecture 1 Introduction, Goals, and Roadmap

Section 2: Relational Databases: Basic structure

Lecture 2 Relational Database Overview

Lecture 3 Database Tables: Rows, Columns, and Primary Keys

Section 3: Data anomalies and data normalization:

Lecture 4 Data Anomalies

Lecture 5 Data Normalization

Lecture 6 Over-normalization

Lecture 7 Recap and Review

Section 4: Data Modeling: Entities, Attributes, and Relationships

Lecture 8 Data Modeling Overview

Lecture 9 Data Modeling: Entity Relationships

Section 5: Project 1: Data Modeling for Client "Downtown Floral"

Lecture 10 Data Modeling Practice: Downtown Floral's initial ERD

Lecture 11 Resolving Many-to-Many Relationships

Lecture 12 Data Modeling for Downtown Floral: Adding Order History

Lecture 13 Data Modeling for Downtown Floral: Adding Delivery Drivers

Lecture 14 Data Modeling for Downtown Floral: Adding Florists to Orders

Section 6: Project 2: Data Modeling for Best Tech U

Lecture 15 Data modeling for Best Tech U: Creating the Initial Data Model

Lecture 16 Data Modeling for Best Tech U: Adding majors

Lecture 17 Data Modeling for Best Tech U: Adding Professors

Section 7: Conclusion and Next Steps

Lecture 18 Conclusion and Next Steps

Current or developing technology professionals who need an introduction to database design.,Anyone needing to design a database to solve a business problem.