Relational Algebra
Given the following set of relations from the East Coast Aquarium database, list the sequence of relational algebra operations needed to implement the queries below.
Species (Species Code, Latin Name, English Name)
Location (Location Code, Place in Building, Size, Head Keeper)
Population (Species Code, Location Code, Number of Animals)
Food (Type of Food)
Feeding (Species Code, Type of Food, Amount of Food, Feeding Interval)
Habitats (Habitat Type)
Can Live (Species Code, Habitat Type)
Where Found (Location Code, Habitat Type)
Source (Source Code, Source Name, Source Address, Source Phone, Contact Person)
Can Supply (Source Code, Species Code)
Shipment (P.O. #, Source Code, Order Date, Order Total $)
Shipment Items (P.O. #, Species Code, Number of Animals, Each $, Line $)
1. List the types of food eaten by species code 155.
2. List the place in the building of all locations that are more than 50 gallons in size.
3. List the types of food eaten by Bottlenose Dolphins.
4. List the English name and species code of each species that live in location code 222.
5. List the English name of all species that can live in a coral reef habitat.
6. List the names of all head keepers who are responsible for Hammerhead Sharks.
7. List the Latin name of all species that eat meal worms.
8. List the Latin name of all species that do not eat mealworms.
9. List the Latin name of all species that do not live in location 1 (the main tank).
10. List the contact person and phone number at each source that can supply harbor seals.
11. List the name of each source from which an animal costing more than $5,000 was ordered.
12. List the English name of all species that were ordered on purchase order # 85093.
13. List the name of all sources that can supply Yellow Tangs, Niger Triggers, and Blue Damselfish.
14. List the names of all sources from which the Aquarium has not ordered in the past two years