Question: Convert the statement into Linear notation (relational algebra): Relational Schema: Classes(class, type, country, numGuns, bore, displacement) Ships(name, class, launched) Battles(name, date) Outcomes(ship, battle, result) List
Convert the statement into Linear notation (relational algebra):
Relational Schema:
Classes(class, type, country, numGuns, bore, displacement)
Ships(name, class, launched)
Battles(name, date)
Outcomes(ship, battle, result)
"List the name, displacement, and number of guns of the ships engaged in the battle of Guadalcanal."
select name, displacement, numGuns from ships,classes,battles where classes.class = ships.class and ships.name = outcomes.ship and outcomes.battle = "Guadalcanal"
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
