Relational Database Design
Ends soon! Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Relational Database Design
This course is part of Databases for Data Scientists Specialization
30,410 already enrolled
Included with
Ask Coursera
355 reviews
Recommended experience
355 reviews
Recommended experience
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
Tools you'll learn
Details to know
See how employees at top companies are mastering in-demand skills
Build your subject-matter expertise
- 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
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://www.coursera.org/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 videos10 readings7 assignments1 discussion prompt
9 videos•Total 105 minutes
- Course Overview•3 minutes
- Data, Information, Knowledge, and Intelligence•6 minutes
- Solutions for Data Management•17 minutes
- Data Stored in DBMS•5 minutes
- What are Entities and Attributes (Identifiers)?•20 minutes
- What are Relationships? Degree, Cardinality and Participation of Relationships•17 minutes
- Entity Relationship Model Representation•3 minutes
- Crow's FootNotation•9 minutes
- In-Class Exercise•24 minutes
10 readings•Total 301 minutes
- Course Updates and Accessibility Support•1 minute
- Welcome and Where to Find Help •10 minutes
- Assessment Strategy•10 minutes
- Assessment Strategy•10 minutes
- Lab 1: Entity Relationship Models•60 minutes
- Lab 1: Solutions •30 minutes
- Lab 2: Entity Relationship Diagrams•60 minutes
- Lab 2: Solutions •30 minutes
- Entity Relationship Models •60 minutes
- Entity Relationship Models: Solutions •30 minutes
7 assignments•Total 73 minutes
- DBMS•10 minutes
- Unlock Lab 1 Solutions •1 minute
- Entities and Relationships•15 minutes
- Unlock Lab 2 Solutions •1 minute
- ERD•15 minutes
- Unlock Entity Relationship Models Solutions •1 minute
- Self Reflection•30 minutes
1 discussion prompt•Total 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 videos•Total 52 minutes
- What are Relations?•12 minutes
- What are Keys?•11 minutes
- What are Relational Schemas?•7 minutes
- How to Convert ERDs to Relational Models•13 minutes
- Practice•9 minutes
8 readings•Total 390 minutes
- Lab 1: Relations•60 minutes
- Lab 1: Solutions •30 minutes
- Lab 2: Relational Schema•60 minutes
- Lab 2: Solutions •30 minutes
- Lab 3: Convert ERDs to Relational Models•60 minutes
- Lab 3: Solutions •30 minutes
- Relational Models •90 minutes
- Relational Models: Solutions •30 minutes
8 assignments•Total 79 minutes
- Unlock Lab 1 Solutions •1 minute
- Relation and Keys•15 minutes
- Unlock Lab 2 Solutions •1 minute
- Relational Schema•15 minutes
- Unlock Lab 3 Solutions •1 minute
- Converting ERD to RM•15 minutes
- Unlock Relational Models Solutions •1 minute
- Relational Models•30 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 videos•Total 66 minutes
- Data Redundancy and Normalization•17 minutes
- Functional Dependencies•9 minutes
- Full, Partial, and Transitive Functional Dependencies•15 minutes
- Normal Forms and Normalization Process•25 minutes
8 readings•Total 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 Process•90 minutes
- Lab 3: Solutions •60 minutes
- Normalization•90 minutes
- Normalization: Solutions •60 minutes
8 assignments•Total 79 minutes
- Unlock Lab 1 Solutions •1 minute
- Data Redundancy•15 minutes
- Unlock Lab 2 Solutions •1 minute
- Functional Dependency•15 minutes
- Unlock Lab 3 Solutions •1 minute
- Normalization Process•15 minutes
- Unlock Normalization Solutions •1 minute
- Normalization•30 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 readings•Total 380 minutes
- Background•30 minutes
- Background: Solutions •30 minutes
- Build the Entity Relationship Model•30 minutes
- Build the Entity Relationship Model: Solutions•30 minutes
- Create the Entity Relationship Diagram•30 minutes
- Create the Entity Relationship Diagram: Solutions •30 minutes
- Convert the ERD to the Relational Model•30 minutes
- Convert the ERD to the Relational Model: Solutions •30 minutes
- Normalize the Relational Model to 3NF•60 minutes
- Normalize the Relational Model to 3NF: Solutions •60 minutes
- Final Output for Implementation•10 minutes
- Final Output for Implementation: Solutions •10 minutes
7 assignments•Total 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 Study•30 minutes
Earn a career certificate
Add this credential to your LinkedIn profile, resume, or CV. Share it on social media and in your performance review.
Build toward a degree
This course is part of the following degree program(s) offered by University of Colorado Boulder. If you are admitted and enroll, your completed coursework may count toward your degree learning and your progress can transfer with you.¹
Instructor
Offered by
Explore more from Data Management
- B
Birla Institute of Technology & Science, Pilani
Course
- Status: PreviewL
Logical Operations
Course
- Status: Free TrialI
Illinois Tech
Course
- Status: Free Trial
Course
Why people choose Coursera for their career
Learner reviews
- 5 stars
76.05%
- 4 stars
17.18%
- 3 stars
3.94%
- 2 stars
1.12%
- 1 star
1.69%
Showing 3 of 355
Reviewed on Sep 8, 2024
Overall the course was good. However, some of the topics like functional dependencies require more explanation.
Reviewed on Mar 14, 2025
The content is very comprehensive and is a perfect match for my UNI's curriculum!
Reviewed on Apr 11, 2026
Thank you so much for this course, It's interesting how a novice like me can understand (in a good way) the form how can use this tool as SQL. Thank you teacher Di , you are the best!
Frequently asked questions
To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.
When you enroll in the course, you get access to all of the courses in the Specialization, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.
Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.
More questions
Financial aid available,