Question
books(id, title author, isbn, goodreads_rating, num_ratings) ratings(id, user_id, book_name, rating) users(id, username, year_joined) books[title] ratings[book_name] users[id] ratings[user_id] The id attribute in all three tables is
books(id, title author, isbn, goodreads_rating, num_ratings)
ratings(id, user_id, book_name, rating)
users(id, username, year_joined)
books[title] ratings[book_name] users[id] ratings[user_id]
The id attribute in all three tables is different! You can think of them in your mind as the book_id, user_id, and rating_id. The title attribute in the Books table is the same as the book_name attribute in the Ratings table. The id attribute in the Users table is the same as the user_id attribute in the Ratings table.
Write a Algebra relationship query to list all book titles rated by user LibreLibrary. Should something like this format.
SNAME(SX(SH(PH=3sP)))
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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