Design Of Database System Course
Question 13 Using the toyu database (which is provided separately), write the SQL query for the following data problem. List the names of students who major in CSCI; do not minor in ITEC; and do not have Mary Tran as faculty advisor. +----- --+ |fName | IName | -+ | Tony | Hawk 1 | Mary | Hawk +----- -+-------+ 2,019 To University (toyu) relations toyu.class: 14 rows total (approximately) classId courseld semester year facid room 10,000 2,000 Fall 1,011 D241 10,001 2,001 Fall 2,019 1,011 D242 10,002 2,002 Fall 2,019 1,012 D136 10,003 2,020 Fall 2,019 1,014 D241 10,004 2,021 Fall 2,019 1,014 D241 10,005 2,040 Fall 2,019 1,015 D237 10,006 2,041 Fall 2,019 1,019 0217 10,007 2,060 Fall 2,019 1,020 B101 10,008 2,080 Fall 2,019 1,018 D241 11,000 2,000 Spring 2,020 1,011 D241 11,001 2,001 Spring 2,020 1,013 D242 11,002 2,002 Spring 2,020 1,013 D136 11,003 2,020 Spring 2,020 1,016 D217 11,004 2,061 Spring 2,020 1,018 B101 toyu.course: 11 rows total (approximately) courseld rubric number name 2,000 CSCI 3333 Data Structures 2,001 CSCI 4333 Design of Dat... 2,002 CSCI 5333 DBMS 2,020 CINF 3321 Introduction t... 2,021 CINE 4320 Web Applicati... 2,040 ITEC 3335 Database Dev... 2,041 ITEC 3312 Introduction t... 2,060 ENGL 1410 English I 2,061 ENGL 1311 English II 2,080 ARTS 3311 Hindu Arts 2,090 ACCT 3333 Managerial Ac... credits 3 3 3 3 3 3 3 4 3 3 3 toyu.department: 7 rows total (approximately) deptCode deptName schoolCode numFaculty ACCT Accounting BUS 10 ARTS Arts HSH 5 CINF Computer Inf... CSE 5 CSCI Computer Sci... CSE 12 ENGL English HSH 12 ITEC Information T... CSE 4 MATH Mathematics CSE 7 toyu.school: 4 rows total (approximately) schoolCode schoolName BUS Business EDU Education HSH Human Sciences and Humanities CSE Science and Engineering toyu.faculty: 11 rows total (approximately) Next facid fname Iname deptCode rank 1,011 Paul Smith CSCI Professor 1,012 Mary Tran CSCI Associate Professor 1,013 David Love CSCI (NULL) 1,014 Sharon Mannes CSCI Assistant Professor 1,015 Daniel Kim CINF Professor 1,016 Andrew Byre CINF Associate Professor 1,017 Deborah ITEC Professor 1,018 Art Allister ARTS Assistant Professor 1,019 Benjamin Yu ITEC Lecturer 1,020 Katrina Bajaj ENGL Lecturer 1,021 Jorginlo Neymar ACCT Assistant Professor Gump toyu.student: 10 rows total (approximately) stuld fname Iname 100,000 Tony Hawk 100,001 Mary Hawk 100,002 David Hawk 100,003 Catherine Lim 100,004 Larry Johnson 100,005 Linda Johnson 100,006 Lillian Johnson 100,007 Ben Zico 100,008 Bill Ching 100,009 Linda King major CSCI CSCI CSCI ITEC ITEC CINE CINF (NULL) ARTS ARTS minor CINF CINE ITEC CINE (NULL) ENGL ITEC (NULL) ENGL CSCI Next s credits advisor 40 1,011 35 1,011 66 1,011 20 1,017 66 1,017 13 1,015 18 1,015 16 (NULL) 90 1,018 125 1,018 To University (toyu) relations toyu.enroll: 22 rows total (approximately) stuld classId grade 100,000 10,000 A 100,001 10,000 (NULL) 100,002 10,000 B- 100,000 10,001 A 100,001 10,001 A- 100,000 10,002 B+ 100,002 10,002 B+ 100,000 10,003 C 100,002 10,003 D 100,004 10,003 A 100,005 10,003 (NULL) 100,000 10,004 A- 100,004 10,004 B+ 100,005 10,004 A- 100,006 10,004 C+ 100,005 10,005 A- 100,006 10,005 A 100,005 10,006 B+ 100,007 10,007 F 100,008 10,007 C- 100,007 10,008 A- 100,000 11,001 D n_alerts 0 (NULL) 3 2 0 1 2 0 4 0 (NULL) 1 (NULL) 0 (NULL) 0 (NULL) (NULL) 4 0 0 4 toyu.grade: 13 rows total (approximately) grade gradePoint A 4.0000 A- 3.6667 B 3.0000 B- 2.6667 B+ 3.3333 2.0000 C- 1.6667 C+ 2.3333 D 1.0000 D- 0.6667 D+ 1.3333 F 0.0000 WX (NULL)
