Lesson 2 of 8Article14 minFREE
ER Model and Data Modeling Basics
ER modeling helps you convert real-world requirements into structured database design. Entities represent objects, attributes represent properties, and relationships represent associations between entities.
Entity-Relationship model
ER modeling helps you convert real-world requirements into structured database design. Entities represent objects, attributes represent properties, and relationships represent associations between entities.
Modeling an education platform
- One-to-one: user and profile settings table.
- One-to-many: course and lessons.
- Many-to-many: students and courses via join table.
Entities and relationships mapping
Entity: Student(student_id, name, email)
Entity: Course(course_id, title, level)
Entity: Enrollment(enrollment_id, student_id, course_id, enrolled_at)
Relationship:
Student 1..N Enrollment N..1 Course