Question: Code the following queries in Tuple Relational Calculus: The following tables include information about tourists, their organizations, some organizations may have planned tours and information
Code the following queries in Tuple Relational Calculus:

The following tables include information about tourists, their organizations, some organizations may have planned tours and information is kept about the tourists to participate in each tour; a tourist may work-for more than one organization. A tourist may participate in any tour whether organized by his/her organization or not. Each tourist has a city and a country where they live which may be different than their citizenship. Note that tid means tourist ID, code means tour code, org_name means organization name, sin_fd1 and sin_fd2 represent sin numbers of a person and his/her friend, citizenship is a country Tour(code, city, country, time, day) Participate(tid, code, class) Works-for(tid.org-name) Tourist(tid, sin, name, citizenship, city, country, age, gender) Organization(name, code, leader-tid, leader-sin, city, year_started) Friend(sin fdl, sin fd2) Code the following queries in Tuple Relational Calculus: g) Find id's of organizations which do not have any Spanish workers? (notice that Spain is a citizenship) h) Find organizations who have German leaders and at least one worker who lives in India
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
