3 Given The Following Tables You Have Been Tasked To Generate A List Of Students One Record Per Student Which Meets 1 (352.53 KiB) Viewed 45 times
3 Given The Following Tables You Have Been Tasked To Generate A List Of Students One Record Per Student Which Meets 2 (275.69 KiB) Viewed 45 times
3) Given the following tables, you have been tasked to generate a list of students, one record per student, which meets the listed required fields and conditions. Describe or list specific queries you would use and your processing steps. Required fields & Conditions: Fields: Student ID, Student Last and First Name, Student Grade Level, Student Gender, Student Ethnicity Conditions: Additionally list any Math course marks (Display fields: Course ID, Course Name, Course Teacher, Course Term and Course Mark) for semesters 1 and 2 and their CAASPP Math scores and performance levels (Display fields: Test Name, Test Version, Test Type, Test Scale Score, Test Performance Level) during the last two years. The list should only include a student if the student had a Math mark of an A or B in either semester or the CAASPP Math Performance Level was met or exceeded in any of the last two years. Students: Stu_ID Lastname 1774589 Zuniga 1788595 Mitchell 187452 Smith 1814582 Grant 199557 Alvarez 178444 Chamberland Courses: Course_ID Course_name 3007 Math 7 6007 English 7 3008 Math 8 8004 Science 8 3011 Algebra I Tests: Test_ID Test_Name 12 CAASPP ENG CAASPP_MATH 13 26 CAASPP_ENG CAASPP_MATH 32 33 43 54 CAASPP_MATH 77 PSAT 82 PSAT PSAT CAASPP ENG Firstname Grade |Amy Katie David Johnny Jacob Richard Department Math English Math Science Math Test_Version 2016-2017 2016-2017 2017-2018 2017-2018 2016-2017 2018-2019 2018-2019 2017-2018 2018-2019 Gender 8 F 7 F 8 M 8 M 7M 8 M Test_Type ENGLISH IMATH ENGLISH IMATH PSAT ENGLISH IMATH PSAT PSAT Ethnicity Hispanic Two or More African American White Hispanic White
Grades: Stu ID Course ID 3008 3008 8004 3011 3008 6007 6007 3007 8004 3008 8004 3011 178444 178444 178444 199557 1774589 1774589 1774589 1788595 1814582 1814582 1814582 199557 77 85 97 Smith, W Smith, W Brown, R Ortiz, U Smith, W Poe, E.A. Poe, E.A. CAASPP ENG CAASPP MATH CAASPP ENG Test Scores: Test_ID Stu ID Teacher Ramirez, S Brown, R Smith, W Brown, R Ortiz, U CAASPP_MATH 26 26 32 26 32 82 32 26 43 54 43 32 54 54 Test Performance Levels: TPL_ID Test Name Performance_Level 102 CAASPP ENG 4 12 CAASPP MATH 22 CAASPP_MATH 4 CAASPP_ENG 68 1 4 A B с B 3 1 3 2 2 с B A F D C D B 1774589 4/22/2018 1788595 4/22/2018 187452 4/28/2018 1814582 4/26/2018 178444 4/26/2018 178444 4/23/2018 1788595 4/22/2018 178444 4/26/2018 178444 4/28/2019 178444 5/1/2019 1774589 5/2/2019 1788595 4/24/2018 Mark 199557 4/30/2019 199557 4/26/2018 S1 S2 S2 $1 S2 S1 S2 S1 $1 S1 S2 S2 Performance_Level_Description Standard Exceeded Standard Not Met Standard Exceeded Standard Met Test_Date Scale_Score Performance Level Term Standard Not Met Standard Met Standard Nearly Met Standard Nearly Met 1855 2522 2744 2610 2210 524 n/a 2411 2610 2444 2345 2200 1200 2545 2100 1 3 4 3 4
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!