Answered step by step
Verified Expert Solution
Question
1 Approved Answer
2. (5 points each) Write the following queries in relational algebra, using the schema provided above. If a query is long, feel free to break
2. (5 points each) Write the following queries in relational algebra, using the schema provided above. If a query is long, feel free to break it up into a series of queries with intermediate answers stored in temporary relations (e.g. "let temp = . *) You can use abbreviations for Relational Algebra symbols such as S for SELECTION, P for PROJECTION, * for NATURAL JOIN,-for SET DIFFERENCE . Your queries must not be "state-dependent", that is, they should work without modification even if another instance of the database is given. . (d) Find the postID, Content and the FullName of the post creator, for each post commented by "Jenny_27" that is in "Mike_34" wall. (e) Retrieve the names of all the Persons who have at least a post without likes and without comments
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started