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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!