Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the PhotoDB schema to answer this question. Provide a relational algebra query that gives a list of names (both first and last) of any

Use the PhotoDB schema to answer this question. Provide a relational algebra query that gives a list of names (both first and last) of any users in the system not tagged in the pictures.

image text in transcribed

PhotoDB is a database for a simple photo sharing web application that allows users to upload photos and tag other users in each photo. It consists of four tables: 1. Users - users of the system. 2. Cameras - basic information about the various cameras used to take photos. Note that a camera is only related to pictures, not to an owner. 3. Pictures - the pictures being stored in the system. a. The location attribute is a user-entered value intended to store the geographical location where the picture was taken... "Boston, MA" or "Paris", for example. 4. Tags - contains information about which users have been tagged in photos. a. A person cannot be tagged in a photo if they aren't already a user in the system

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

Understand the concept and application of IoT analytics in HRM

Answered: 1 week ago