Sunny Oaks Summerday Park Elementary School Figure 1. CLASS ROSTERS with telephone contact information Directory ROSTER MOSPES serves several neighborhoods in NorthWest Dallas. The MOSPES PTA publishes a directory for parents each year GRADE 3 TEACHER June Newhouse Student ned in the ROOM A195 Figures 1, 2, and 3 below represent sample pages from the 3 sections contai DirectorY .A listing of teachers, by grade Parent information Class rosters (by teacher, within grade) with telephone contact info 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 214-785-1234 (cell) 214-785-1234 (cell) Anderson, Taylor C 214441-7555 (home) Jim 214-441-7555 (home) 214-229-5555 (cel) Barden, Billie (home) Kate Varden 214-333-5555 (home) Edward214-333-5555 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. 214-777-7779 (cell) 830-411-1234 214777-7777 (cell) Cardenas, Marissa H 830-411-1234 (home) Arturo (home) Use Figures 1, 2, and 3 and their associated descriptions as the basis for a relationa database design. Also consider #5 in your list of deliverables. 214-835-5555 (cell) Cieata May 214-261-2612 home) Miies 214-847-7777 (cell) 214-261-2612 Davis, Myles home) 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. Perry 214-789-7899 (cell) Ferguson, Maynard Olve 214-515-5151 (cell) 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 l 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 contalning parent information) Sunny Oaks Summerday Park Elementary School Figure 1. CLASS ROSTERS with telephone contact information Directory ROSTER MOSPES serves several neighborhoods in NorthWest Dallas. The MOSPES PTA publishes a directory for parents each year GRADE 3 TEACHER June Newhouse Student ned in the ROOM A195 Figures 1, 2, and 3 below represent sample pages from the 3 sections contai DirectorY .A listing of teachers, by grade Parent information Class rosters (by teacher, within grade) with telephone contact info 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 214-785-1234 (cell) 214-785-1234 (cell) Anderson, Taylor C 214441-7555 (home) Jim 214-441-7555 (home) 214-229-5555 (cel) Barden, Billie (home) Kate Varden 214-333-5555 (home) Edward214-333-5555 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. 214-777-7779 (cell) 830-411-1234 214777-7777 (cell) Cardenas, Marissa H 830-411-1234 (home) Arturo (home) Use Figures 1, 2, and 3 and their associated descriptions as the basis for a relationa database design. Also consider #5 in your list of deliverables. 214-835-5555 (cell) Cieata May 214-261-2612 home) Miies 214-847-7777 (cell) 214-261-2612 Davis, Myles home) 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. Perry 214-789-7899 (cell) Ferguson, Maynard Olve 214-515-5151 (cell) 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 l 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 contalning parent information)