Sunny Oaks Summerday Park Elementary School Directory MOSPES serves several neighborhoods in NorthWest Dallas. The MOSPES PTA publishes a directory for parents each year. Figures 1, 2, and 3 below represent sample pages from the 3 sections contained in the Directory .A listing of teachers, by grade .Class rosters (by teacher, within grade) with telephone contact info D Family listings Assume that all parents have given signed permission for their students to be listed in the directory and for all information in the database to be published in the directory (This is a big assumption!!) That is, anything that is in the database can be printed in the directory.) Assume that you do not need to track these permissions All students must have at least one parent (or legal guardian) listed. Most students will have 2 parents (or guardians) listed. Regardless of the situation, the directory cannot list more than 2 parents for a given student. All teachers will be given a grade-level class (K 5). A student can be assigned to one and only one class Use Figures 1, 2, and 3 and their associated descriptions as the basis for a relational database design. Also consider #5 in your list of deliverables 1. 1. Using the information above, the attached figures and your list of deliverables to create an E-R diagram for the data required to produce the Directory. At a minimum, you should include the following entities: STUDENT, FAMILY, TEACHER State any simplifying assumptions which you make in developing the E-R model * Illustrate your final model in Visio and save as a pdf file. You will submit this when you submit your database via BB 2. 2. Create a relational model for the data needed to produce the Directory. Identify primary keys and referential integrity constraints. Note: If you have not previously identified a unique primary key for each table from the attributes given in the case, you will need to add one (or more) attributes to serve as a primary key. Create a relationship report within your database. This will show your relationship model. [under database tools...] 3. 3. Implement the relational model (from #2 above) as a MS Access database (2003 is preferable). Enter sample data. (At a minimum, 3 grades, 5 teachers, 4 classes, 40 students, 10 families containing parent information)