day 3: Er Diagram

📘 What is an ER Diagram?

ER = Entity Relationship Diagram
It shows:

• Entities = Tables (like Student, Course)
• Relationships = Connection between tables (like Student belongs to a Course)

📊 ER Diagram Overview (in this Project)

This diagram contains 12 tables (entities) and their relationships.

Let's go one by one:

---

1. 🧑‍🎓 Student

• Main entity.

• Every student has:

  • Name, mobile, email, etc.
  • A selected course → 🔁 Many students to One Course
  • Many fee records → 🔁 One student to many Fee
  • Many attendance entries → 🔁 One student to many Attendance
  • Can give feedback → 🔁 One student to many Feedback
  • Belongs to a batch → 🔁 Many students to One Batch

---

2. 📘 Course

• Contains:

  • courseName, duration, fee, syllabus

• Connected to:

  • Many students → 🔁 One course to many students
  • Many faculties → 🔁 One course to many faculties

---

3. 🧑‍🏫 Faculty

• Belongs to one course → 🔁 Many faculty to one course
• Helps to know which teacher teaches which course

---

4. 💰 Fee

• Fee paid by student

• Every fee has:

  • Amount, payment date, receipt no

• Linked to one student → 🔁 Many fee entries for one student

---

5. 🕒 Attendance

• Records each day's presence/absence
• Every attendance entry belongs to one student

---

6. ✍️ Feedback

• Student gives review/rating
• Many feedback entries for one student

---

7. ⏰ Batch

• Groups of students (e.g., Morning/Evening)
• One batch has many students

---

Other Tables (Not linked in diagram)

Table Name	Description
User	Login system (admin/student/faculty)
LoginAttempt	Logs failed login attempts (fraud check)
Notification	Email/SMS sent logs
AuditLog	Tracks admin changes
Enquiry	Stores form submitted from website (public)

These are optional helper tables – don’t need direct relationships.

---

✅ Summary of Key Relationships

From	To	Relationship
Student	Course	ManyToOne
Student	Fee	OneToMany
Student	Attendance	OneToMany
Student	Feedback	OneToMany
Student	Batch	ManyToOne
Course	Faculty	OneToMany

---

• "My system uses a normalized database schema."
• "This ER diagram shows how each student is linked to a course, fees, attendance, and feedback."
• "We follow relational integrity using @ManyToOne, @OneToMany JPA annotations."

---

S