Learn the basics of Entity Relationship Diagram

Name: Learn the basics of Entity Relationship Diagram
Rating: 4.2 (58 reviews)

For database design

Created byYanling Chin

Last updated 12/2021

English

What you'll learn

Creating an Entity Relationship Diagram (ERD) for a database design from scratch.
Recognising the entities and creating them that are needed for the design of the database system.
Creating the attributes for the entities in the ERD including the keys.
Recognising the relationships between entities and creating these relationships.

Course content

2 sections • 8 lectures • 1h 4m total length

Introduction & Additional material5:45
The two files contain the additional material used in this course. Please download them and use them for reference.

Lesson 1 - ERD Entities (has exercise)8:03
After finishing the lesson, the student knows what are entities and can practice identifying entities using the exercise. The exercise is included as a pdf file and is also mentioned during the lesson.
Lesson 2 - ERD Entities (exercise answers)7:42
The student will see the answers to the exercise from the first lesson. The student will understand why these entities were chosen.
Lesson 3 - ERD Attributes (has exercise)8:12
In this lesson the student will learn about ERD attributes and know what they are.
The student can then practice with the included exercise (it's in the lesson); to add the attributes to the entities.
Lesson 4 - ERD Entity Attributes (exercise answers part I)7:10
In this exercise, the student will be able to see what attributes are used for the entities from the exercise.
The student can check if his/her answers are similar.
Lesson 5 - ERD Entity Attributes (exercise answers part II)7:06
The student sees the answers to the exercise about the entity attributes to use. This is the second part of the entity attributes.
Lesson 6 - ERD Entity Relationships (has exercise)11:05
In this lesson, the student learns about the different entity relationships that are used for the connections between the various entities. At the end, an exercise is waiting for the student to apply the learnt knowledge of adding the entity relations to the entities.
Lesson 7 - ERD Entity Relationships (exercise answers)9:29
This is the final lesson.
The student learns about the solutions for the entity relationships from the previous lesson's exercise and understands why those relationships are used.
Now the student is equipped with the basic knowledge of how to make an ERD.

Requirements

The willingness to learn, no prior knowledge is needed, beginners are welcome.

Description

Whenever you come into contact with data that is stored in a database, you need to learn how to retrieve the data, how to add new data and how to modify and delete existing data from the tables in a database.

These tables or entities are set up in a certain way, they have connections with one another.

Before we even start to create the tables, unless they are already there, we need to have a design. We need to think of what tables we need, what are the column names and their values, and what are the keys and how they relate to other tables.

We can make this design using ERD. ERD is there to help design a database.

If you are a developer or an aspiring developer, who will inevitably work with databases at some point, then it is good to know how to design a database system. Needless to say, a database designer needs to know this as it is their job to create database systems.

Content of the course

The course consists of 7 lessons with a total duration of 58 minutes 46 seconds.
The exercises that come with the lessons are aiming towards creating an ERD with a case scenario. The exercises’ solutions are also explained in the lessons.

At the end of the course, you will have the basics to make your very own ERD.

This is an overview of the lessons and their content. In the brackets is the duration of each lesson.

Lesson 1: ERD Entities (has exercise) (08:03)
Lesson 2: ERD Entities (exercise answers) (07:42)
Lesson 3: ERD Entity Attributes (has exercise) (08:12)
Lesson 4: ERD Entity Attributes (exercise answers part 1) (07:10)
Lesson 5: ERD Entity Attributes (exercise answers part 2) (07:06)
Lesson 6: ERD Entity Relationships (has exercise) (11:04)
Lesson 7: ERD Entity Relationships (exercise answers) (09:29)

Who this course is for:

Beginner database designer or a software developer or anyone who has interest in creating an ERD.

Learn the basics of Entity Relationship Diagram

What you'll learn

Explore related topics

Course content

Additional material1 lecture • 6min

Lessons7 lectures • 59min

Requirements

Description

Who this course is for: