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

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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!