MySQL

Heading 1 Norme The database is posted as TV-University-Database. Key to Transcript is: (CrsCode, Semester Section) Section Grode StudId 666666666 666666666 666666666 987654321 987654321 123454321 123454321 123454321 023456789 023456789 Transcript Semester MGT123 F1994 EE101 $1991 MAT123 F1997 CS305 F1995 MGT123 F1994 CS315 51997 CS305 S1996 MAT123 S1996 EE101 F1995 CS305 S1996 EE101 F1997 MAT123 F1997 MGT123 F1997 MGT123 F1997 MST123 F1994 111111111 111111111 321001234 876006789 Key to Teaching is: (CrsCode, Semester. Section) Section Teaching ProfId CrsCode Semester 0094063211 M6T123 F1994 121232343 EE101 S1991 555666777 CS305 F1995 864297531 MGT123 F1994 101202303 CS315 $1997 900120450 MAT123 51996 121232343 EE101 F1995 101202303 CS305 51996 900120450 MAT123 F1997 783432188 MGT123 F1997 009406321 MGT123 F1997 es) Key to Professor is: Id Name S alary Age 650 MentorId 555666777 00940621 864297531 6 0000 Id 101202303 783432188 121232343 864297531 555666777 009406321 900120450 987654321 Adrian Jones David Jones Qi Chen Mary Doe J acob Taylor Ann White Albert Engy | Deptid CS MGT EE CS MGT MAT Key to Course is: CrsCode Deptid CS CesCode CS305 CS315 MGT123 EE101 MAT123 Course CesName111111 Database Systems Transaction Processing Market Analysis Electronic Circuits CS High-Paying Job Recover Worst Crashes Get Rich Quick Build Your Own What Started It Al EE Key to Student is: Id Student Major NE MGT Id Name 111223344 Mary Smith 987654321 Bart Simpson 111111111 John Doe 023456789 Simpson 666666666 Joseph Public 123454321 Joe Blow 321001234 Walter White 876006789 Jesse Pinkman Freshman Senior Freshman Senior cs Homer MGT Address Gpa 1 Lake St. 12.50 Fox 5 TV 3 .00 123 Main St. 3.50 Fox 5 TV 2.75 666 Hollow Rd 3.75 6 Yard C 2.55 10 Albug LA 3.50 5 Adobe Ct. 3.00 CS EE Sophomore Junior Senior Sophomore CS CS D Focus 3) List all professors who are working for the CS or EE departments. Perform this using two distinct query types. (One of the types must involve a set operation) 6) Find the names of the professors and names of the courses they taught in which Bart Simpson was a student in fall of 1994. (This query involves all 5 tables) 7) Find all professors who have mentors. 8) Find all professors who do not have mentors. 9) Who are the professors who have mentors who are