ER Diagram of Primary school

Entity‐Relationship Diagram For a Primary School

 Assumptions for ER-Diagram: While drawing the ER diagram for primary school, we had some assumption which is as follows:‐ 1. One teacher can teach multiple subjects 2. There is no elective /optional subject for any of the of  the class in primary school. 3. In school, only one guardian name will be mentioned in database and hence it is one‐to‐ one relationship. 4. One student cannot be associated with more than one class. Where as in one class, many number of student of  student will be studying. 5. One teacher can teach in several classes and in one class several teachers can teach different subjects and hence it is “many‐to‐many” relationship. 6. One student can be thought by many teacher and vice‐versa is also acceptable and hence it is “many‐to‐many” relationship 7. One student need to pay fee every month, so that one student need to pay fee several time

Entity‐Relationship Diagram For a Primary School

mid_name Room_no Init_name

Last_name

standard

section Section

1 class

Phone Phone no

date_of_birth

name study

address

N

age

Email Student student_id

Phone no

M

M

1

class

has Teaches

1 pay

Subject

Employee_id

has

N

Phone Phone no

Bill_no

N

address

Teacher

sl_no

N

student_id

Relationship

Email Guardian

date_of_birth age

Phone Phone no

Date_of_payment

name

Fee datail datail Email Init_name

Fee_period

Last_name

name Init_name

mid_name

Year

Month

Last_name

mid_name

2|Page