$**1.$ ER Diagram:$**$

$[$ER Diagram Image$]$

$**$Entities and Attributes:$**$

$-**$School:$**$

$-$ Name

$-$ Address $($Street Address, Parish, County$)$

$-$ Type $($Basic$,$ Prep, Primary, Junior High, High$)$

$-$ Grade

$-**$Employee:$**$

$-$ Name $($First Name, Last Name$)$

$-$ Address

$-$ Date of Birth

$-$ Age

$-$ Start Date

$-$ Contact Numbers

$-$ Job Title

$-$ Annual Salary

$-$ Teaching Aid Allowance $($for academic employees$)$

$-$ Bonus $($for administrative employees$)$

$-$ Bi$-$weekly Wage

$-$ Hourly Rate

$-$ Supervised By $($Foreign Key referencing Employee$)$

$-**$Supply:$**$

$-$ Name

$-$ Type

$-$ Description

$-$ Quantity

$-$ Date Received

$-**$Inspection:$**$

$-$ Date of Inspection

$-$ Findings

$-$ Inspector's Name

$-**$Warning Letter:$**$

$-$ Date of Letter

$-$ List of Violations

$-**$Appraisal:$**$

$-$ Period Covered

$-$ Level of Attendance

$-$ Meeting Deadlines

$-$ Punctuality

$-$ Adherence to Policies

$-$ Job Performance

$-$ Performance Details

$**$Relationships:$**$

$-$ Each School hires multiple Employees.

$-$ Each Employee is supervised by another Employee.

$-$ Schools receive multiple Supplies.

$-$ Each School is inspected multiple times.

$-$ Employees receive annual Appraisals.

$**2.$ Additional Entities:$**$

a$.**$Parent$/$Guardian:$**$

$-$ Name

$-$ Address

$-$ Contact Numbers

$-$ Relationship to Student

$-$ Occupation

$**$Importance:$**$ Parents or guardians play a vital role in a student's education. They are important stakeholders in the school system and have a direct relationship with the students and the school. They need to be informed about their child's performance, behavior, and any school$-$related matters.

b$.**$Extracurricular Activities:$**$

$-$ Activity Name

$-$ Description

$-$ Date$/$Time

$-$ Location

$-$ Supervising Teacher

$**$Importance:$**$ Extracurricular activities contribute to the overall development of students. They provide opportunities for students to explore their interests, develop skills, and build relationships outside of the academic curriculum. Supervising teachers oversee these activities and play a role in enhancing the student experience.

c$.**$Health Records:$**$

$-$ Medical History

$-$ Allergies

$-$ Medications

$-$ Emergency Contacts

$-$ Physician Information

$**$Importance:$**$ Health records are essential for ensuring the well$-$being of students and staff. They provide valuable information about medical conditions, allergies, and emergency contacts. Schools need to maintain accurate health records to address medical needs and respond effectively to emergencies.

$**3.$ Relational Notation:$**$

$**$School $($Name$,$ Address, Type, Grade$)**$

$-$ School$\_$Name $($Primary Key$)$

$-$ Street$\_$Address

$-$ Parish

$-$ County

$-$ Type

$-$ Grade

$**$Employee $($Name$,$ Address, Date$\_$of$\_$Birth, Age, Start$\_$Date, Contact$\_$Numbers, Job$\_$Title, Annual$\_$Salary, Teaching$\_$Aid$\_$Allowance, Bonus, Bi$\_$weekly$\_$Wage, Hourly$\_$Rate, Supervised$\_$By$)**$

$-$ Employee$\_$ID $($Primary Key$)$

$-$ First$\_$Name

$-$ Last$\_$Name

$-$ Address

$-$ Date$\_$of$\_$Birth

$-$ Age

$-$ Start$\_$Date

$-$ Contact$\_$Numbers

$-$ Job$\_$Title

$-$ Annual$\_$Salary

$-$ Teaching$\_$Aid$\_$Allowance

$-$ Bonus

$-$ Bi$\_$weekly$\_$Wage

$-$ Hourly$\_$Rate

$-$ Supervised$\_$By $($Foreign Key referencing Employee$\_$ID$)$

$**$Supply $($Name$,$ Type, Description, Quantity, Date$\_$Received$)**$

$-$ Supply$\_$ID $($Primary Key$)$

$-$ Name

$-$ Type

$-$ Description

$-$ Quantity

$-$ Date$\_$Received

$**$Inspection $($Date$\_$of$\_$Inspection, Findings, Inspector$\_$Name$)**$

$-$ Inspection$\_$ID $($Primary Key$)$

$-$ Date$\_$of$\_$Inspection

$-$ Findings

$-$ Inspector$\_$Name

$**$Warning$\_$Letter $($Date$\_$of$\_$Letter, List$\_$of$\_$Violations$)**$

$-$ Warning$\_$Letter$\_$ID $($Primary Key$)$

$-$ Date$\_$of$\_$Letter

$-$ List$\_$of$\_$Violations

$**$Appraisal $($Period$\_$Covered, Level$\_$of$\_$Attendance, Meeting$\_$Deadlines, Punctuality, Adherence$\_$to$\_$Policies, Job$\_$Performance, Performance$\_$Details$)**$

$-$ Appraisal$\_$ID $($Primary Key$)$

$-$ Period$\_$Covered

$-$ Level$\_$of$\_$Attendance

$-$ Meeting$\_$Deadlines

$-$ Punctuality

$-$ Adherence$\_$to$\_$Policies

$-$ Job$\_$Performance

$-$ Performance$\_$Details

$**$Parent$\_$Guardian $($Name$,$ Address, Contact$\_$Numbers, Relationship$\_$to$\_$Student, Occupation$)**$

$-$ Parent$\_$Guardian$\_$ID $($Primary Key$)$

$-$ Name

$-$ Address

$-$ Contact$\_$Numbers

$-$ Relationship$\_$to$\_$Student

$-$ Occupation

$**$Extracurricular$\_$Activities $($Activity$\_$Name, Description, Date$\_$Time, Location, Supervising$\_$Teacher$)**$

$-$ Activity$\_$ID $($Primary Key$)$

$-$ Activity$\_$Name

$-$ Description

$-$ Date$\_$Time

$-$ Location

$-$ Supervising$\_$Teacher

$**$Health$\_$Records $($Medical$\_$History, Allergies, Medications, Emergency$\_$Contacts, Physician$\_$Information$)**$

$-$ Health$\_$Record$\_$ID $($Primary Key$)$

$-$ Medical$\_$History

$-$ Allergies

$-$ Medications

$-$ Emergency$\_$Contacts

$-$ Physician$\_$Information