Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

* * 1 . ER Diagram: * * [ ER Diagram Image ] * * Entities and Attributes: * * - * * School: *

**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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Marketing Database Analytics

Authors: Andrew D. Banasiewicz

1st Edition

0415657881, 978-0415657884

Students also viewed these Databases questions

Question

2 The main characteristics of the market system.

Answered: 1 week ago