Skip to content
Select language
Skip to search
OpenClassrooms.com
OpenClassrooms.com
Training programs
Our training programs
Online and at your own pace.
Compare our training programs
Learn a profession
Degree programs
Acquire in-demand skills with real-world projects and one-to-one mentoring.
Discover a topic
Free-access courses
Broaden your knowledge with 500+ regularly updated courses
Apprenticeship
Apprenticeship
Online and at your own pace.
Students
Start an apprenticeship
Kick off a new career with our 100% online registered apprenticeship degrees, which offer a monthly salary and no fees.
Consult job opportunities
Access thousands of apprenticeship job opportunities across France all year round.
Employers
Hire apprentices
Access qualified candidates all year round, create a job posting with AI, or receive a tailored selection of top talent.
Finalize the hiring of a candidate
Found the perfect candidate? Share their details to proceed with the hiring process.
For employers
For employers
Train and recruit talents through an all-in-one space.
Discover our solution
Upskilling & reskilling
Enhance your knowledge
with a library of 500+ self-guided courses - SPARK
Promote hard and soft skills
with mentor-led intensive programs - BOOST
Support career progression
with mentor-led training programs - PIVOT
Recruitment
Foster talents
Access qualified candidates all year round, create a job offer with AI, or receive a tailored selection of top talent.
Finalize the hiring of a candidate
Found the perfect candidate? Share their details to proceed with the hiring process.
Get help
Design the Logical Model of Your Relational Database
Table of contents
Part 1
What Is a Relational Database?
1
Get the Most Out of This Course
2
Compare Relational and NoSQL Databases
3
Make Use of a Database Management System (DBMS)
4
Choose the Right Data Type
Quiz: Identify the Basics of Relational Databases
Part 2
Design your logical model
1
Connect Your Data With a Relational Data Model
2
Identify Database Integrity Constraints
3
Build a Solid Database Foundation Through Normalization
4
Normalize to the First, Second, and Third Normal Forms
5
Put it all Together
6
Get some practice by designing an ERD
Quiz: Check What You've Learned About Structuring a Relational Database!
Table of contents
Part 1
What Is a Relational Database?
1
Get the Most Out of This Course
2
Compare Relational and NoSQL Databases
3
Make Use of a Database Management System (DBMS)
4
Choose the Right Data Type
Quiz: Identify the Basics of Relational Databases
Part 2
Design your logical model
1
Connect Your Data With a Relational Data Model
2
Identify Database Integrity Constraints
3
Build a Solid Database Foundation Through Normalization
4
Normalize to the First, Second, and Third Normal Forms
5
Put it all Together
6
Get some practice by designing an ERD
Quiz: Check What You've Learned About Structuring a Relational Database!
Check What You've Learned About Structuring a Relational Database!
Question 1
Question 2