Databases- physical er diagram. please use pgmodeler
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 Your job, as a database developer, is to design a set of third normal form relations that wil accommodate the data required by CCHS's teachers and staff. Keep in mind that the people who prepared the preceding outline know very little about database design, which means that the way in which they organized their data requirements may have little relationship to the actual design of the database. Deliverables (10 points) You will provide a pgModeler diagram exported as a PNG. You will be graded as follows: 1-Missing an entity .-0.5- Missing an attribute .-0.5-for each error in Proper diagramming & structure (naming conventions, etc.) .Plagiarism will result in Zero Marks .1 -Missing or misrepresenting a relationship 2 not well normalized is the design 1 Point-Naming the file incorrectly. The file should be named: Last Name- First Name - Assignment 1.png 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 Your job, as a database developer, is to design a set of third normal form relations that wil accommodate the data required by CCHS's teachers and staff. Keep in mind that the people who prepared the preceding outline know very little about database design, which means that the way in which they organized their data requirements may have little relationship to the actual design of the database. Deliverables (10 points) You will provide a pgModeler diagram exported as a PNG. You will be graded as follows: 1-Missing an entity .-0.5- Missing an attribute .-0.5-for each error in Proper diagramming & structure (naming conventions, etc.) .Plagiarism will result in Zero Marks .1 -Missing or misrepresenting a relationship 2 not well normalized is the design 1 Point-Naming the file incorrectly. The file should be named: Last Name- First Name - Assignment 1.png
