- 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!
1
Discussions
- Introduce Yourself!
2
Readings
- Welcome and Where to Find Help
- Assessment Strategy
Introduction to DBMS
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
- 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
- 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
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
- 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
- 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
- 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
1
Assignment
- Relational Models
2
Readings
- Relational Models
- Relational Models: Solutions
1
Quiz
- Unlock Relational Models Solutions
Why We Care about Normalization?
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
- 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
- Normal Forms and Normalization Process
2
Readings
- Lab 3: Normalization Process
- Lab 3: Solutions
2
Quiz
- Unlock Lab 3 Solutions
- Normalization Process
Assignments
1
Assignment
- Normalization
2
Readings
- Normalization
- Normalization: Solutions
1
Quiz
- Unlock Normalization Solutions
Step 1
2
Readings
- Background
- Background: Solutions
1
Quiz
- Unlock Step 1 Solutions
Step 2
2
Readings
- Build the Entity Relationship Model
- Build the Entity Relationship Model: Solutions
1
Quiz
- Unlock Step 2 Solutions
Step 3
2
Readings
- Create the Entity Relationship Diagram
- Create the Entity Relationship Diagram: Solutions
1
Quiz
- Unlock Step 3 Solutions
Step 4
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
- Normalize the Relational Model to 3NF
- Normalize the Relational Model to 3NF: Solutions
1
Quiz
- Unlock Step 5 Solutions
Step 6
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