provide a draft of the Entity Relationship Diagram (ERD) to the discussion thread for peer feedback. Discuss any areas you are struggling and need advice. 

 

Transcribed Image Text:

622 unit 2 (1) - Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Paste * Cut Copy Format Painter Calibri 11 A A ab Wrap Text General Normal Bad Good BIU A Merge & Center $ %, .0.00 .00 .0 Conditional Format as Neutral Calculation Check Cell Insert Delete Format Formatting Table Clipboard Font Alignment Number Styles Cells D22 ch srikanth AutoSum Fill Clear AT Sort & Find & Filter Select Editing 0 A B C D E LL 1 Dataset: Chicago Public Schools - Progress Report Cards 2 Field name Field name in database Data type Description Required? NULL value al 3 School ID School ID integer School unique ID yes no 4 Name of school 5 street Add 6 city School_name string name of the school yes no street_add string location of the school yes no city string city of the school yes no 7 zip code zip char zip code yes no 8 Phone Number 9 Collaborative Name 10 Environment Score 11 Teachers Icon 12 Leaders Icon 13 Average Student Attendance 14 College Eligibility % 15 Graduation Rate % Phone Number char phone number of the school yes no 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 16 Students Passing Algebra % Students Passing Algebra % float Students Passing in Algebra percentage yes no 17 Students Taking Algebra % 18 CPS Performance Policy Level 19 Safety Score 20 Instruction Score 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 22 22 23 24 Sheet1 (+) Ready Accessibility: Good to go 28C Partly sunny 3 Search prime video Buds EPIC W GAMES > B E ENG IN 7:03 PM 6/20/2023 159% 622 unit 2 (1) - Excel File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Paste * Cut Copy Format Painter Calibri 11 A A ab Wrap Text General Normal Bad Good BIU A Merge & Center $ %, .0.00 .00 .0 Conditional Format as Neutral Calculation Check Cell Insert Delete Format Formatting Table Clipboard Font Alignment Number Styles Cells D22 ch srikanth AutoSum Fill Clear AT Sort & Find & Filter Select Editing 0 A B C D E LL 1 Dataset: Chicago Public Schools - Progress Report Cards 2 Field name Field name in database Data type Description Required? NULL value al 3 School ID School ID integer School unique ID yes no 4 Name of school 5 street Add 6 city School_name string name of the school yes no street_add string location of the school yes no city string city of the school yes no 7 zip code zip char zip code yes no 8 Phone Number 9 Collaborative Name 10 Environment Score 11 Teachers Icon 12 Leaders Icon 13 Average Student Attendance 14 College Eligibility % 15 Graduation Rate % Phone Number char phone number of the school yes no 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 16 Students Passing Algebra % Students Passing Algebra % float Students Passing in Algebra percentage yes no 17 Students Taking Algebra % 18 CPS Performance Policy Level 19 Safety Score 20 Instruction Score 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 22 22 23 24 Sheet1 (+) Ready Accessibility: Good to go 28C Partly sunny 3 Search prime video Buds EPIC W GAMES > B E ENG IN 7:03 PM 6/20/2023 159%