Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Circus : Tourist : Cno C 1 C 2 C 3 City Gaza Nusirat Gaza Tno T 1 T 2 T 3 T 4 TS

Circus : Tourist : Cno C1 C2 C3 City Gaza Nusirat Gaza Tno T1 T2 T3 T4 TS Name Sami Amal Majed Majed Ali Address Gaza Gaza Nusirat Gaza Rafa Age 5520314520 Visiting : Tno Cno Date T2 T1 T2 T2 C1 C3 C2 C3 T111-11-199815-10-199911-01-200311-01-200306-03-202106-03199711-11-200911-11-201912-12-2020 C2 C1 C3 C3 T3 T3 T4 T2 C2- Express each of the following queries in the relational algebra queries : 1- Determine Tno and Names of all Tourists who have not visited any Circus at all. 2- List all Tourists who have visited all Circus in Gaza. 3- List Tno and Names of Tourists who live in Nusirat and visited the Circus in Nusirat yesterday.

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

Students also viewed these Databases questions

Question

Discuss the different types of leadership

Answered: 1 week ago

Question

Write a note on Organisation manuals

Answered: 1 week ago

Question

Define Scientific Management

Answered: 1 week ago

Question

Explain budgetary Control

Answered: 1 week ago

Question

Decision Making in Groups Leadership in Meetings

Answered: 1 week ago