Relational Database Design

Relational Database Design

This course is part of Databases for Data Scientists Specialization

Instructor: Di Wu

Access provided by Coursera Learning Team

23,969 already enrolled

4 modules

Gain insight into a topic and learn the fundamentals.

4.6

(294 reviews)

Beginner level

Recommended experience

Flexible schedule

Approx. 34 hours

Learn at your own pace

97%

Most learners liked this course

4 modules

Gain insight into a topic and learn the fundamentals.

4.6

(294 reviews)

Beginner level

Recommended experience

Flexible schedule

Approx. 34 hours

Learn at your own pace

97%

Most learners liked this course

What you'll learn

Create Entity Relationship Models and Entity Relationship Diagrams
Create Relational Models
Normalize a Relational Model to 3NF

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

30 assignments

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

Build your subject-matter expertise

This course is part of the Databases for Data Scientists Specialization

When you enroll in this course, you'll also be enrolled in this Specialization.

Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

There are 4 modules in this course

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://kidlove.top/degrees/master-of-science-data-science-boulder.

Introduce students to Database Management Systems. Introduce and train students with how to build conceptual entity relationship models.

What's included

9 videos9 readings7 assignments1 discussion prompt

9 videosTotal 104 minutes

Course Overview3 minutesPreview module
Data, Information, Knowledge, and Intelligence6 minutes
Solutions for Data Management17 minutes
Data Stored in DBMS5 minutes
What are Entities and Attributes (Identifiers)?19 minutes
What are Relationships? Degree, Cardinality and Participation of Relationships16 minutes
Entity Relationship Model Representation3 minutes
Crow's foot notation9 minutes
In-Class Exercise24 minutes

9 readingsTotal 300 minutes

Welcome and Where to Find Help 10 minutes
Assessment Strategy10 minutes
Assessment Strategy10 minutes
Lab 1: Entity Relationship Models60 minutes
Lab 1: Solutions 30 minutes
Lab 2: Entity Relationship Diagrams60 minutes
Lab 2: Solutions 30 minutes
Entity Relationship Models 60 minutes
Entity Relationship Models: Solutions 30 minutes

7 assignmentsTotal 73 minutes

DBMS10 minutes
Unlock Lab 1 Solutions 1 minute
Entities and Relationships15 minutes
Unlock Lab 2 Solutions 1 minute
ERD15 minutes
Unlock Entity Relationship Models Solutions 1 minute
Self Reflection30 minutes

1 discussion promptTotal 30 minutes

Introduce Yourself!30 minutes

Introduce the concepts about relational models. Train students with how to convert a conceptual entity relationship model to a relational model.

What's included

5 videos8 readings8 assignments

5 videosTotal 51 minutes

What are Relations?11 minutesPreview module
What are Keys?10 minutes
What are Relational Schemas?7 minutes
How to Convert ERDs to Relational Models13 minutes
Practice9 minutes

8 readingsTotal 390 minutes

Lab 1: Relations60 minutes
Lab 1: Solutions 30 minutes
Lab 2: Relational Schema60 minutes
Lab 2: Solutions 30 minutes
Lab 3: Convert ERDs to Relational Models60 minutes
Lab 3: Solutions 30 minutes
Relational Models 90 minutes
Relational Models: Solutions 30 minutes

8 assignmentsTotal 79 minutes

Unlock Lab 1 Solutions 1 minute
Relation and Keys15 minutes
Unlock Lab 2 Solutions 1 minute
Relational Schema15 minutes
Unlock Lab 3 Solutions 1 minute
Converting ERD to RM15 minutes
Unlock Relational Models Solutions 1 minute
Relational Models30 minutes

Introduce students with the reasons and process of normalization. Train students with skills to normalize a relational model to 3NF.

What's included

4 videos8 readings8 assignments

4 videosTotal 66 minutes

Data Redundancy and Normalization16 minutesPreview module
Functional Dependencies9 minutes
Full, Partial, and Transitive Functional Dependencies15 minutes
Normal Forms and Normalization Process25 minutes

8 readingsTotal 480 minutes

Lab 1: Functional Dependencies 60 minutes
Lab 1: Solutions 30 minutes
Lab 2: Identify Special FDs 60 minutes
Lab 2: Solutions 30 minutes
Lab 3: Normalization Process90 minutes
Lab 3: Solutions 60 minutes
Normalization90 minutes
Normalization: Solutions 60 minutes

8 assignmentsTotal 79 minutes

Unlock Lab 1 Solutions 1 minute
Data Redundancy15 minutes
Unlock Lab 2 Solutions 1 minute
Functional Dependency15 minutes
Unlock Lab 3 Solutions 1 minute
Normalization Process15 minutes
Unlock Normalization Solutions 1 minute
Normalization30 minutes

A summary of the knowledge we learned in this course, starting from an Entity Relationship Model to a Relational Model in 3NF and ready for implementation.

What's included

12 readings7 assignments

12 readingsTotal 380 minutes

Background30 minutes
Background: Solutions 30 minutes
Build the Entity Relationship Model30 minutes
Build the Entity Relationship Model: Solutions30 minutes
Create the Entity Relationship Diagram30 minutes
Create the Entity Relationship Diagram: Solutions 30 minutes
Convert the ERD to the Relational Model30 minutes
Convert the ERD to the Relational Model: Solutions 30 minutes
Normalize the Relational Model to 3NF60 minutes
Normalize the Relational Model to 3NF: Solutions 60 minutes
Final Output for Implementation10 minutes
Final Output for Implementation: Solutions 10 minutes

7 assignmentsTotal 36 minutes

Unlock Step 1 Solutions 1 minute
Unlock Step 2 Solutions 1 minute
Unlock Step 3 Solutions 1 minute
Unlock Step 4 Solutions 1 minute
Unlock Step 5 Solutions 1 minute
Unlock Step 6 Solutions 1 minute
Case Study30 minutes

Instructor

Instructor ratings

4.4 (105 ratings)

Di Wu

University of Colorado Boulder

21 Courses47,462 learners

Offered by

University of Colorado Boulder

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

4.6

294 reviews

5 stars
74.82%
4 stars
17.68%
3 stars
4.08%
2 stars
1.36%
1 star
2.04%

Showing 3 of 294

Reviewed on May 30, 2022

Great course, good materials and instructors taught well!

Reviewed on Mar 15, 2025

The content is very comprehensive and is a perfect match for my UNI's curriculum!

Reviewed on Apr 2, 2025

It is a very well structured course. My only observation is in the normalization lecture, it could be more easy. Using Coach AI was very helpful for me to understand the content in a more easy way.

View more reviews