Monthly Subscription Starting at AED 99 + VAT

Relational Database Design
  • Level Foundation
  • Duration 71 hours
  • Course by University of Colorado Boulder
  • Offered by

About

Have you ever wanted to build a database but don't know where to start? This course will provide you a step-by-step guidance. We are going to start from a raw idea to an implementable relational database. Getting on the path, practicing the real-life mini cases, you will be confident and comfortable with Relational Database Design. Let's get started! Relational Database Design can be taken for academic credit as part of CU Boulder’s Master of Science in Data Science (MS-DS) degree offered on the Coursera platform. The MS-DS is an interdisciplinary degree that brings together faculty from CU Boulder’s departments of Applied Mathematics, Computer Science, Information Science, and others. With performance-based admissions and no application process, the MS-DS is ideal for individuals with a broad range of undergraduate education and/or professional experience in computer science, information science, mathematics, and statistics. Learn more about the MS-DS program at https://www.coursera.org/degrees/master-of-science-data-science-boulder.

Modules

Welcome to Relational Database Design!

    • 2 Readings
    • 1 Discussion
Show info about module content

1 Discussions

  • Introduce Yourself!

2 Readings

  • Welcome and Where to Find Help
  • Assessment Strategy

Introduction to DBMS

    • 4 Videos
    • 1 Readings
    • 1 Quiz
Show info about module content

4 Videos

  • Course Overview
  • Data, Information, Knowledge, and Intelligence
  • Solutions for Data Management
  • Data Stored in DBMS

1 Readings

  • Assessment Strategy

1 Quiz

  • DBMS

Entities and Their Relationships

    • 2 Videos
    • 2 Readings
    • 2 Quiz
Show info about module content

2 Videos

  • What are Entities and Attributes (Identifiers)?
  • What are Relationships? Degree, Cardinality and Participation of Relationships

2 Readings

  • Lab 1: Entity Relationship Models
  • Lab 1: Solutions

2 Quiz

  • Unlock Lab 1 Solutions
  • Entities and Relationships

Entity Relationship Diagram and Notations

    • 3 Videos
    • 2 Readings
    • 2 Quiz
Show info about module content

3 Videos

  • Entity Relationship Model Representation
  • Crow's foot notation
  • In-Class Exercise

2 Readings

  • Lab 2: Entity Relationship Diagrams
  • Lab 2: Solutions

2 Quiz

  • Unlock Lab 2 Solutions
  • ERD

Assignments

    • 2 Readings
    • 1 Quiz
    • 1 Assignment
Show info about module content

1 Assignment

  • Self Reflection

2 Readings

  • Entity Relationship Models
  • Entity Relationship Models: Solutions

1 Quiz

  • Unlock Entity Relationship Models Solutions

Relation and Keys

    • 2 Videos
    • 2 Readings
    • 2 Quiz
Show info about module content

2 Videos

  • What are Relations?
  • What are Keys?

2 Readings

  • Lab 1: Relations
  • Lab 1: Solutions

2 Quiz

  • Unlock Lab 1 Solutions
  • Relation and Keys

Relational Schema

    • 1 Videos
    • 2 Readings
    • 2 Quiz
Show info about module content

1 Videos

  • What are Relational Schemas?

2 Readings

  • Lab 2: Relational Schema
  • Lab 2: Solutions

2 Quiz

  • Unlock Lab 2 Solutions
  • Relational Schema

Convert ERD to Relational Schemas

    • 2 Videos
    • 2 Readings
    • 2 Quiz
Show info about module content

2 Videos

  • How to Convert ERDs to Relational Models
  • Practice

2 Readings

  • Lab 3: Convert ERDs to Relational Models
  • Lab 3: Solutions

2 Quiz

  • Unlock Lab 3 Solutions
  • Converting ERD to RM

Assignments

    • 2 Readings
    • 1 Quiz
    • 1 Assignment
Show info about module content

1 Assignment

  • Relational Models

2 Readings

  • Relational Models
  • Relational Models: Solutions

1 Quiz

  • Unlock Relational Models Solutions

Why We Care about Normalization?

    • 2 Videos
    • 2 Readings
    • 2 Quiz
Show info about module content

2 Videos

  • Data Redundancy and Normalization
  • Functional Dependencies

2 Readings

  • Lab 1: Functional Dependencies
  • Lab 1: Solutions

2 Quiz

  • Unlock Lab 1 Solutions
  • Data Redundancy

Functional Dependencies and Normalization Forms

    • 1 Videos
    • 2 Readings
    • 2 Quiz
Show info about module content

1 Videos

  • Full, Partial, and Transitive Functional Dependencies

2 Readings

  • Lab 2: Identify Special FDs
  • Lab 2: Solutions

2 Quiz

  • Unlock Lab 2 Solutions
  • Functional Dependency

Normalization Process to 3NF

    • 1 Videos
    • 2 Readings
    • 2 Quiz
Show info about module content

1 Videos

  • Normal Forms and Normalization Process

2 Readings

  • Lab 3: Normalization Process
  • Lab 3: Solutions

2 Quiz

  • Unlock Lab 3 Solutions
  • Normalization Process

Assignments

    • 2 Readings
    • 1 Quiz
    • 1 Assignment
Show info about module content

1 Assignment

  • Normalization

2 Readings

  • Normalization
  • Normalization: Solutions

1 Quiz

  • Unlock Normalization Solutions

Step 1

    • 2 Readings
    • 1 Quiz
Show info about module content

2 Readings

  • Background
  • Background: Solutions

1 Quiz

  • Unlock Step 1 Solutions

Step 2

    • 2 Readings
    • 1 Quiz
Show info about module content

2 Readings

  • Build the Entity Relationship Model
  • Build the Entity Relationship Model: Solutions

1 Quiz

  • Unlock Step 2 Solutions

Step 3

    • 2 Readings
    • 1 Quiz
Show info about module content

2 Readings

  • Create the Entity Relationship Diagram
  • Create the Entity Relationship Diagram: Solutions

1 Quiz

  • Unlock Step 3 Solutions

Step 4

    • 2 Readings
    • 1 Quiz
Show info about module content

2 Readings

  • Convert the ERD to the Relational Model
  • Convert the ERD to the Relational Model: Solutions

1 Quiz

  • Unlock Step 4 Solutions

Step 5

    • 2 Readings
    • 1 Quiz
Show info about module content

2 Readings

  • Normalize the Relational Model to 3NF
  • Normalize the Relational Model to 3NF: Solutions

1 Quiz

  • Unlock Step 5 Solutions

Step 6

    • 2 Readings
    • 1 Quiz
    • 1 Assignment
Show info about module content

1 Assignment

  • Case Study

2 Readings

  • Final Output for Implementation
  • Final Output for Implementation: Solutions

1 Quiz

  • Unlock Step 6 Solutions

Auto Summary

"Relational Database Design" is a foundational IT & Computer Science course offered by CU Boulder on Coursera. Ideal for beginners, it guides you step-by-step from conceptualizing to implementing a relational database, with practical mini-cases to build confidence. Part of the MS-DS degree, it includes interdisciplinary insights from Applied Mathematics, Computer Science, and Information Science. The course spans 4260 minutes and is available via a Starter subscription. Perfect for those with diverse educational backgrounds in related fields. Enroll now to kickstart your database design journey!

Di Wu
Instructor

Di Wu