Answered step by step
Verified Expert Solution
Question
1 Approved Answer
* * 1 . ER Diagram: * * [ ER Diagram Image ] * * Entities and Attributes: * * - * * School: *
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
Biweekly 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.
Additional Entities:
aParentGuardian:
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 schoolrelated matters.
bExtracurricular Activities:
Activity Name
Description
DateTime
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.
cHealth Records:
Medical History
Allergies
Medications
Emergency Contacts
Physician Information
Importance: Health records are essential for ensuring the wellbeing 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.
Relational Notation:
School Name Address, Type, Grade
SchoolName Primary Key
StreetAddress
Parish
County
Type
Grade
Employee Name Address, DateofBirth, Age, StartDate, ContactNumbers, JobTitle, AnnualSalary, TeachingAidAllowance, Bonus, BiweeklyWage, HourlyRate, SupervisedBy
EmployeeID Primary Key
FirstName
LastName
Address
DateofBirth
Age
StartDate
ContactNumbers
JobTitle
AnnualSalary
TeachingAidAllowance
Bonus
BiweeklyWage
HourlyRate
SupervisedBy Foreign Key referencing EmployeeID
Supply Name Type, Description, Quantity, DateReceived
SupplyID Primary Key
Name
Type
Description
Quantity
DateReceived
Inspection DateofInspection, Findings, InspectorName
InspectionID Primary Key
DateofInspection
Findings
InspectorName
WarningLetter DateofLetter, ListofViolations
WarningLetterID Primary Key
DateofLetter
ListofViolations
Appraisal PeriodCovered, LevelofAttendance, MeetingDeadlines, Punctuality, AdherencetoPolicies, JobPerformance, PerformanceDetails
AppraisalID Primary Key
PeriodCovered
LevelofAttendance
MeetingDeadlines
Punctuality
AdherencetoPolicies
JobPerformance
PerformanceDetails
ParentGuardian Name Address, ContactNumbers, RelationshiptoStudent, Occupation
ParentGuardianID Primary Key
Name
Address
ContactNumbers
RelationshiptoStudent
Occupation
ExtracurricularActivities ActivityName, Description, DateTime, Location, SupervisingTeacher
ActivityID Primary Key
ActivityName
Description
DateTime
Location
SupervisingTeacher
HealthRecords MedicalHistory, Allergies, Medications, EmergencyContacts, PhysicianInformation
HealthRecordID Primary Key
MedicalHistory
Allergies
Medications
EmergencyContacts
PhysicianInformation
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started