Question: Here is the three questions I need help with: 1. Create a database in PostgreSQL named courses. 2. The database will contain three relations with

Here is the three questions I need help with:

Here is the three questions I need help with: 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)

Q6 Find all students that enrolled in some course taught only by

professors that they like. 07 Find all students that enrolled in some

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) 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. teaches professor course enrolls student course likes student professor 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!