Sample questions Students Courses Snum Sname Major GPA Dept Code Title CrHr 101 102 103 104 105 106 IS IS 2.5 IS IS MKT 301 MKT 304 300 301 Intro to MIS Statistics Intro to Marketing Int'1 Marketing Cindy David Ellen Frank FIN MKT IS 2.4 Classes Enrollments CalNum Dept Code Section# Semester SNUM CallNum GRADE 10111 10112 10113 10114 10115 10116 10117 300 300 301 300 300 301 301 101 102 103 101 102 103 103 102 10111 10111 10111 10114 0116 0116 10114 10114 IS IS IS 2004Fa 2004Fa 2004Fa 2005Sp 2005Sp 2005Sp 2005Sp IS MKT MKT 1. draw ERD for these tables. a. What is the relationship of students with classes? (Based on the above tables), what will the following query return? Table: Enrollments, Students Link: Enrollments Snum Students Snum Criteria: Maior-IS" Show: Calnum 2. 3. (Based on the above tables), what will the following query return? Table: Enrollments, Students Link: EnrolUments.Snum Students.Snym Criteria: Major-"IS, and Grade-"A" Show: name b) 10111, 10114 c) Andy, Betty d) Andy, Betty, Cindy e) Andy, Betty, Frank 4. (Based on the above tables), we setup the query as follows: Query1 Students Snum Sname Major Field: Major Table Students Snum Students Descendine Sname Students Sort Show: Criteria: IS Who is showing up at the first row? a) David b) Andy c) Frank d) Betty e) None of the above