Up next in 10
ER Diagram Explained in 10 Minutes | Easy Guide for Beginners
2K views
May 21, 2025
Earn the fundamentals of database design with this comprehensive guide to ER diagrams! An Entity-Relationship (ER) diagram is a visual representation of data entities and their relationships, used in software engineering, business information systems, and education. In this video, we'll delve into the concept of ER diagrams, their components, and how they're used to model complex data structures. Whether you're a student, programmer, or data analyst, understanding ER diagrams is essential for designing and implementing efficient databases. So, watch till the end to gain a solid grasp of ER diagrams and take your database skills to the next level! #erdiagram #erdiagramtutorils
View Video Transcript
0:00
hi friends welcome to tutors funny
0:02
channel today I'm going to teach teach
0:04
about the ER
0:06
diagram so if you are a software
0:09
developer you must know what is ER
0:13
diagram without ER diagram we can't do
0:16
the software project in ER diagram is
0:20
very
0:21
important before you are make the
0:24
software projects okay so I have made
0:27
the ER diagram consider about the
0:30
Twitter jobs okay the Twitter jobs
0:33
portal if you have no idea you can go
0:35
here you can type
0:38
Twitter
0:41
jobs okay I not even connect my internet
0:45
you can have idea what is a tutor job
0:50
so
0:52
here t jobs mean so you can hire the
0:56
teacher
0:57
online okay student can student teacher
1:00
will be able to post the job so I am the
1:04
max teacher who can able to post a job
1:07
uh student also post the job so I need a
1:11
max teacher okay so that's how that
1:14
that's how the uh Twitter job is working
1:18
student easily find their respective
1:20
teacher the teacher also
1:24
uh can post the job okay the teacher can
1:28
uh find the bunch of students so that's
1:32
how that system will be works okay so
1:35
that's kind of system when you are
1:37
doing consider about that kind of system
1:40
i made the ER diagram before we have to
1:43
do the system
1:45
so first we have to identify the what
1:46
are the actors are available that
1:49
particular system so the theater jobs
1:53
the student and teacher those are the
1:57
main actors of the
1:59
system okay so another one is a
2:02
admin admin mean you mean who is the
2:05
admin mean the person who control the
2:08
system the person who own the system so
2:11
I am uh I'm I I have developed the
2:15
uh Twitter jobs management system so so
2:20
I am I was into the internet so that
2:24
particular system any instructor can
2:27
join the system any student can join the
2:30
system that but I am the
2:33
admin admin user i can first the the
2:37
teacher who registered the particular
2:39
system first I have to see the teachers
2:43
all the qualification and everything
2:45
after that I can verify the teacher okay
2:48
so after that student also the same
2:49
thing I first I'm going to review the
2:50
student details after the verify the
2:52
students everything I can
2:55
uh everything I can manage by the admin
2:59
okay the teacher also we can give
3:03
uh some Priv privileges that student we
3:07
are not do student can't uh allow the
3:11
that kind of a privileges to student the
3:13
teacher can imagine teacher can assign
3:17
the assignments teacher can assign the
3:20
exams the everything uh do by teacher
3:24
only not student okay student can only
3:26
can uh view the exam paper and student
3:31
can view the exam result then the only
3:33
thing student can do those kind of
3:35
everything we have a we have to do the
3:37
this system you can give the different
3:39
privileges okay so that we have to
3:41
consider about the things before you
3:42
make the software what are the what is
3:44
the privileges given to this particular
3:47
person not what is the privileges not
3:49
given to this particular person
3:51
everything you have to identify before
3:52
you have to going to do the software
3:55
otherwise the while you the middle of
3:58
the software you you get the struggling
4:02
you
4:03
cannot you cannot do the software
4:12
uh
4:13
Sorry you you you cannot uh make the
4:17
software well so that we have to first
4:19
you have to make the proper
4:20
documentation that is very important
4:21
stuff without the documentation you have
4:23
struggling in the software so these are
4:26
the things very must you have before you
4:28
have to implement the software so you
4:30
can see this is the that user consist of
4:33
three student teacher and admin so here
4:37
you have to make it as a one user you
4:40
have to create the table on your
4:42
database only one table which is user
4:45
this user table is all the roles name
4:48
email address all the things are the
4:52
student this name email location and
4:54
form these are common to every user but
4:57
the some of the things this the
4:59
education experience this this is the
5:01
only field uh only come to teacher it's
5:05
not come to the student so we have to
5:07
add those field as well so here only one
5:10
table you have to create it this one
5:12
table we have to the user is a one table
5:18
you have to insert student and teacher
5:21
and admin okay so you have to
5:22
additionally you have to create the role
5:24
only here so that that's efficient way
5:26
to do the software okay if you like you
5:29
can create separate manage by separate
5:31
tables student is one table teacher is
5:33
one table and B is one table but that is
5:35
not efficient way to do the software the
5:37
efficient way to you have to create one
5:39
table user you have to manage by the
5:41
three different roles okay so it's
5:44
naming of an diagram is a relationship
5:48
user is a I mean is a student user is a
5:54
teacher user is
5:56
admin okay have you understand that okay
6:00
that what is the point I have explained
6:03
this is very important stuff when you
6:04
are making the software okay so after
6:07
that right now come to the main point so
6:11
here there is a tweet about job this is
6:14
job quarter after complete the
6:16
registration here we have a only thing
6:18
the user registration we have completed
6:20
in this process after complete the
6:23
registration what the next thing of the
6:26
year diagram we have
6:28
to go into the posted tutor jobs
6:32
students also can post a t job at the
6:35
same time teacher also can positive jobs
6:38
okay admin is not doing anything else he
6:40
just manage the system and and all only
6:43
two persons have managed everything okay
6:45
so in order to do this we have
6:49
to do the relationship so you can see
6:53
teacher
6:54
and teacher job what is the relationship
6:57
in in between
6:59
them i have here I have tell that many
7:02
to many so here you have to write bit
7:05
the many teacher can beat many t jobs
7:09
okay so you can see one teacher you have
7:11
to consider about one teacher can apply
7:14
one only one t jobs no there are many t
7:19
job the teacher
7:21
can offer okay you
7:25
can at the same time you can look at
7:27
that from the tutor jobs to teacher from
7:30
the teacher to teacher only one teacher
7:32
can
7:34
apply only uh only one can one teacher
7:39
can apply only one tutor job no one job
7:42
can apply many many teachers if it is a
7:45
max there students post one job as a max
7:48
teacher the max
7:51
teacher the that particular job there
7:53
are many teacher can
7:55
beat okay so finally the student can
7:58
identify which teacher is good for me
8:01
and we can give the order so the one t
8:03
job can apply for many teachers at the
8:07
same time many teacher can apply many t
8:09
jobs so many to many one teacher can
8:12
apply many tutor jobs okay so one can
8:14
one teacher can apply many t jobs at the
8:17
same time the one job can apply many
8:21
teachers so many to many relationship
8:24
understand that first you have first you
8:26
have to take about this teacher one
8:29
teacher can apply many t jobs okay so
8:31
one teacher only can apply many the job
8:34
no the one job we have a max teacher
8:38
that the one job uh the students
8:41
students courses there's a max teacher I
8:43
needed that that particular job can
8:46
access plenty of teachers not only one
8:49
teachers not to apply that job there are
8:51
plenty of teacher who join that system
8:54
all teachers can teach uh the the
8:56
teacher who who can teach maxwell those
8:59
all the teachers that can apply
9:02
particular job so many to many
9:03
relationship
9:05
after the student 10 t what is the
9:08
relationship here one student post many
9:11
t jobs okay I am the one teacher one
9:14
student I can post many tutor jobs but
9:17
student is
9:20
one okay students is one okay if you go
9:24
to that the job student can post that
9:26
this job mean many student can post many
9:30
job that is not this one student can
9:32
post job i am the student i can post a I
9:37
need a max
9:38
teacher and I need a science teacher i
9:42
need a
9:44
uh programming teacher so the one can
9:48
force many tutor jobs the tutor jobs
9:50
other hand you have to look at the T
9:52
from the T jobs to student one student
9:56
can apply many T jobs okay this how we
9:59
have do the things
10:02
so another important part review so
10:05
what's a review after student the
10:07
teacher done the course
10:09
well okay
10:11
student satisfy teachers uh how the
10:15
teachers perform how the teachers
10:17
explain okay so that that
10:21
experiment at the end of the course
10:24
shouldn't leave the review okay the
10:26
review very important stuff
10:30
uh important stuff it can boost the
10:32
teachers
10:35
uh enhance the
10:36
teachers
10:38
uh jobs okay it is it it can boost the
10:42
teachers job it can enhance teachers
10:45
jobs okay so you can see the review the
10:49
one teacher
10:52
can one can one teacher is one teacher
10:55
can leave many reviews the same thing
10:57
one student can leave many reviews the
11:00
student can satisfy the uh teachers
11:06
uh explanation well the student can
11:08
leave many reviews okay so the same time
11:11
the student teacher also leave the many
11:13
reviews one teacher okay but teacher is
11:16
one okay so that you can understand them
11:20
simple stuff okay that's the thing you
11:22
have to do right another one is a
11:25
proportion that's very important
11:28
stuff okay the proportion proportion
11:30
mean that T jobs are
11:33
proportional so that student that the
11:35
teacher one teacher can submit many job
11:41
proportion one teacher can submit many
11:44
job proportion we can
11:47
do so here also the many prop proposal
11:51
as one t
11:53
jobs you can understand that many
11:56
proposal as one t jobs so this is the
12:02
simple diagram we have drawn okay so we
12:05
have to this is the simple diagram you
12:08
drawn
12:09
just check it
12:11
everything you have understand this how
12:14
that we have to make the system okay
12:16
this one all the things we are not
12:17
concerned about this this one uh I have
12:19
to remove them this one we no needed
12:21
only this thing you are concerned about
12:22
it okay tables I have created here okay
12:26
so here you can do
12:28
it okay thank you for watching
#Business & Productivity Software
#Education
#Educational Software
#Enterprise Technology
#Helpdesk & Customer Support Systems
#Jobs & Education
#Software
#Teaching & Classroom Resources