Question: Need help with this question, the correct outputs are this for the following 3 questions: Output for #6: s11, s12 Output for #7: s4, s5,
Need help with this question, the correct outputs are this for the following 3 questions:
Output for #6: s11, s12 Output for #7: s4, s5, s6, s7, s8, s9, s10, s12 Output for #8: s1, s2, s5, s7, s9, s10, s12





1. Create a database in PostgreSQL named courses. 2. The database will contain three relations with the schema: Likes (student, professor) Enrolls (student, course) Teaches (professor, course) teaches professor enrolls student course course likes student professor Q6 Find all students that enrolled in some course taught only by professors that they like. 07 Find all students that enrolled in some course taught by some professor that they don't like. Q8 Find all students that enrolled in some course taught only by professors that they don't like. CREATE TABLE likes ( student varchar(50), professor varchar(50) ); CREATE TABLE enrolls ( student varchar(50), course varchar(50) ); CREATE TABLE teaches ( professor varchar(50), course varchar(50) ); load table insert into likes (student, professor) values ('sl', 'Einstein'); insert into likes (student, professor) values ('sl', 'Feynman'); insert into likes (student, professor) values ('52', 'Einstein'); insert into likes (student, professor) values ('52', 'Feynman'); insert into likes (student, professor) values ('53', 'Einstein'); insert into likes (student, professor) values ('s', 'Einstein'); insert into likes (student, professor) values ('56', 'Feynman'); insert into likes (student, professor) values ('58', 'Feynman'); insert into likes (student, professor) values ('s11', 'p41'); insert into likes (student, professor) values ('511', 'p42'); insert into likes (student, professor) values ('s12', 'p41'); insert into enrolls(student, course) values ('sl', 'c1'); insert into enrolls(student, course) values ('sl', 'c2'); insert into enrolls (student, course) values ('52', 'c2'); insert into enrolls (student, course) values ('sl', 'c3'); insert into enrolls(student, course) values ('54', 'c4'); insert into enrolls (student, course) values ('55', '64'); insert into enrolls (student, course) values ('56', 'c5'); insert into enrolls (student, course) values ('s7', 'c5'); insert into enrolls(student, course) values ('58', 'c5'); insert into enrolls(student, course) values ('59', 'c5'); insert into enrolls(student, course) values ('310', 'c5'); insert into enrolls(student, course) values ('s11', '641'); insert into enrolls(student, course) values ('s11', '642'); insert into enrolls (student, course) values ('812', 'c41'); insert into enrolls (student, course) values ('512', 'c42'); I insert into teaches (professor, course) values ('Einstein', 'c4'); insert into teaches (professor, course) values ('Einstein', 'c5'); insert into teaches (professor, course) values ('Einstein', 'c6'); insert into teaches (professor,course) values ('Feynman', 'c4'); insert into teaches (professor, course) values ('Feynman', 'c5'); insert into teaches (professor, course) values ('Feynman', 'c7'); insert into teaches (professor, course) values ('p41', 'c41'); insert into teaches (professor, course) values ('p42', 'c42')
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
