Students student_id a1111111 given_name family_name Fang Li a1111112 Jane Brown program BE(Hons)(Soft) BE(Hons)(Soft) BC

[answerhappygod]

Students Student Id A1111111 Given Name Family Name Fang Li A1111112 Jane Brown Program Be Hons Soft Be Hons Soft Bc 1 (88.4 KiB) Viewed 48 times

Students student_id a1111111 given_name family_name Fang Li a1111112 Jane Brown program BE(Hons)(Soft) BE(Hons)(Soft) BCompSc BCompSc a1111113 Bob Smith a1111114 Wei Zhang Subjects subject_code subject faculty COMP SCI 1102 Object Oriented Programming ECMS COMP SCI 2207 Web and Database Computing ECMS COMP SCI 2000 Computer Systems ECMS PHIL 2039 Philosophy of Mind Arts Enrolments student_id subject_code mark a1111111 COMP SCI 1102 62 a1111111 COMP SCI 2000 80 a1111112 COMP SCI 1102 55 a1111112 COMP SCI 2207 80 a1111113 PHIL 2039 65 a1111113 COMP SCI 1102 46 a1111114 COMP SCI 2207 67 a1111114 COMP SCI 2000 49
Task 3.7 (5 points) . The provided database contains additional information about the course coordinator of each subject (not included in Part 2) . Write a SQL query to list the details (attributes and their data types) of the table containing the course coordinator information. • Save the query in a file named query3-7.591 Tips • See this page for details on getting information about databases. Task 3.8 (6 points) • Jane Brown (a1111112) is leaving the University (I'm very sad about this, Jane). - Write a SQL query to remove Jane from the subjects she is enrolled in. • Write a SQL query to remove Jane from the database. • Save both queries in a file named query3-8.sql , each on a new line. • Don't forget the Semicolon ; at the end of each query. Task 3.9 (7 points) • Who have been Bob Smith's (a1111113) teachers in the ECMS faculty? o Write a SQL query to list the id and name (given, family) of each of Bob's course coordinator. . Only list the coordinators of Subjects from the ECMS faculty. See Task 3.7 for details on course-coordinators. • Save the query in a file named query3 -9.591 Task 3.10 (8 points) • Who's taking broadening electives? . Write a SQL query that, for each student taking one or more subjects outside of the ECMS faculty, lists the student's name (given, family), the student's program/degree, the name of the subject, and which faculty the subject is run by. • Save the query in a file named query3-10.591