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. In MS Access, create a report to print class rosters (Figure 1) 2. Create a form to switch a student from one class to another, within the same grade. ?.g. from Ms. Norms 2nd grade class to Mr. Whalen's 2nd grade class. 3. Show how to answer the following questions using SQL in MS Access: a. For a given grade, how many students are in each class? (Your query should prompt the user for the grade. The answer table should contain teacher last name and a count for each teacher in the grade.) b. List (in alphabetical order) the students who are currently in Kindergarten c. Optional for extra credit: Which family has the most children in MOSPES? 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. In MS Access, create a report to print class rosters (Figure 1) 2. Create a form to switch a student from one class to another, within the same grade. ?.g. from Ms. Norms 2nd grade class to Mr. Whalen's 2nd grade class. 3. Show how to answer the following questions using SQL in MS Access: a. For a given grade, how many students are in each class? (Your query should prompt the user for the grade. The answer table should contain teacher last name and a count for each teacher in the grade.) b. List (in alphabetical order) the students who are currently in Kindergarten c. Optional for extra credit: Which family has the most children in MOSPES
