Relational Database Design

Relational Database Design

This course is part of Databases for Data Scientists Specialization

Instructor: Di Wu

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

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://roshoesn.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.