provide an Entity Relationship Diagram (ERD) based on the data below: A B 1 Dataset: Chicago Public

provide an Entity Relationship Diagram (ERD) based on the data below:
 

 

Transcribed Image Text:

A B 1 Dataset: Chicago Public Schools - Progress Report Cards C D E FL 2 Field name 3 School ID Field name in database Data type Description Required? NULL value al School ID integer School unique ID yes no 4 Name of school 5 street Add School_name string name of the school yes no street_add string location of the school yes no 6 city 7 zip code 8 Phone Number 9 city string city of the school yes no zip char zip code yes no Phone Number char phone number of the school yes no Collaborative Name 10 Environment Score 11 Teachers Icon 12 Leaders Icon 13 Average Student Attendance 14 College Eligibility % 15 Graduation Rate % 16 Students Passing Algebra % 17 Students Taking Algebra % 18 CPS Performance Policy Level 19 Safety Score 20 Instruction Score Collaborative Name string part of the colaberation yes no Environment Score integer Environment Score yes no Teachers Icon integer describing the quality of teacher yes no Leaders Icon integer describing the quality of leader yes no Average Student Attendance float Students average attendance yes no College_Eligibility_% float college eligibility percentage yes no Graduation Rate % float college Graduation percentage yes no Students Passing Algebra % float Students Passing in Algebra percentage yes no Students Taking Algebra % float Students Taking Algebra percentage yes no CPS Performance Policy Level Safety Score string CPS Performance Policy Level yes no integer Safety Score yes no Instruction Score integer Instruction Score yes no 21 Parent Engagement Score Parent Engagement Score integer Parent Engagement Score yes no A B 1 Dataset: Chicago Public Schools - Progress Report Cards C D E FL 2 Field name 3 School ID Field name in database Data type Description Required? NULL value al School ID integer School unique ID yes no 4 Name of school 5 street Add School_name string name of the school yes no street_add string location of the school yes no 6 city 7 zip code 8 Phone Number 9 city string city of the school yes no zip char zip code yes no Phone Number char phone number of the school yes no Collaborative Name 10 Environment Score 11 Teachers Icon 12 Leaders Icon 13 Average Student Attendance 14 College Eligibility % 15 Graduation Rate % 16 Students Passing Algebra % 17 Students Taking Algebra % 18 CPS Performance Policy Level 19 Safety Score 20 Instruction Score Collaborative Name string part of the colaberation yes no Environment Score integer Environment Score yes no Teachers Icon integer describing the quality of teacher yes no Leaders Icon integer describing the quality of leader yes no Average Student Attendance float Students average attendance yes no College_Eligibility_% float college eligibility percentage yes no Graduation Rate % float college Graduation percentage yes no Students Passing Algebra % float Students Passing in Algebra percentage yes no Students Taking Algebra % float Students Taking Algebra percentage yes no CPS Performance Policy Level Safety Score string CPS Performance Policy Level yes no integer Safety Score yes no Instruction Score integer Instruction Score yes no 21 Parent Engagement Score Parent Engagement Score integer Parent Engagement Score yes no