Databases---3NF Phsical ER diagram

edar Canoe High Schoo Cedar Canoe High School (CCHS) is a new facility under construction in Porquis Junction, ON. Jesse Strictman, who will become the new school's first principal, has been given a great deal of freedom to configure the school's information systems. Mr. Strictman therefore called a meeting of his teaching and administrative staff to discuss what they need in the basic database that will support the operation of the school. The result of the meeting was the outline that appears below: 1. Student data o Name o Address o Birthdate o Gender o Legal guardian(s) o Date enrolled o Date unenrolled (date graduated, date transferred to another school, or date dropped out 2. Legal guardian data o Name o Address o Birthdate o Gender o Children responsible for o Home phone 3. Enrollments o Courses enrolled in o Location of each course o Grades for each course 4. Disciplinary actions o Name of student o Date of incident o Type of incident o Disciplinary action taken 5. Extracurricular activities o Name of student o Academic year o Name of clubs/sports teams participating in/office held, etc. o Offices/positions held 6. Post high school plans o Colleges/post-secondary education applied to o Date of applications o Result of applications (accept/reject/wait list) o College/post-secondary education chosen