Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

List the astronauts names ( astroname ) , year of death, and age at year of death ( death - birth ) of all astronauts

List the astronauts names (astroname), year of death, and age at year of death (death
- birth) of all astronauts who have dead and the age of death was greater than 65,
Order by year of death. With the given data, the result of the correct query will be: from This database describes the United States space program, prior to the
-- space shuttle.
--
-- If you are concerned that NASA history is not relevant
-- to a Business-oriented student, you are wrong: Forom a business perspective
-- these are just projects, and the astronauts are "just" workers assigned to
-- one or more tasks (ie. missions).
--
-- Prior to the shuttle, NASA ran five different "manned" space projects:
--
-- Project Mercury (1961-63): The six missions of this project carried a
-- single astronaut, the 'pilot'. The first two missions were sub-orbital
--(missionType ='SO') and four missions that took the astronauts into
-- Earth orbit (missionType ='EO').
--
-- Project Gemini (1965-66): Each of the 10 manned missions of this
-- program carried two astronauts, the 'Commander' and 'Pilot', into Earth
-- orbit (missionType ='EO').(The first manned mission was number 3, the
-- first two were unmanned tests.)
--
-- Project Apollo (1967-1972): Each of these missions carried three
-- astronauts, the 'Commander', 'Command Module Pilot', and 'Lunar Module
-- Pilot. Most missions used two spacecraft, the 'Command Service Module'
--(craftType='CSM') and the 'Lunar Module' (craftType='LM'). In most
-- missions (missionType ='LL'), the Command Module Pilot would stay in
-- lunar orbit in the CSM, while the Commander and Lunar Module Pilot
-- descended in the LM. Apollo 11 was the first mission to land on the
-- moon. Earlier missions were test flights. Apollo 1 did not fly
--(hence the missionType of this mission has been left null). The crew of
-- Apollo 1 was killed while testing the spacecraft on the launch pad.
-- The first manned Apollo mission was Apollo 7. It tested a CSM in earth
-- orbit (missionType ='EO') and did not have a lunar module. Apollo 8
-- tested a CSM in lunar orbit (missionType ='LO') and also did not have
-- a lunar module. Apollo 9 tested a LM in Earth orbit, and Apollo 10
-- tested a LM in lunar orbit. From Apollo 11 onward, all missions landed
-- on the moon (missionType ='LL'), with one exception, Apollo 13, which
-- aborted its mission on the way to the moon, and looped round the moon
-- without entering orbit (a "Fly By", missionType='LF').
--
-- Project Skylab (1973): Skylab 1 was the launch of the first US space
-- station, in Earth orbit. Each of Skylab missions 2 to 4 took a
-- three-man crew to the Skylab station in an Apollo CSM. The third member
-- of each crew was called the scientist (not Lunar Module Pilot).
--
-- Project Apollo-Soyuz (1975): A three-man crew in an Apollo CSM docked
-- with a Russian Soyuz spacecraft in Earth orbit. The third member of
-- that crew was called the Docking Module Pilot (not Lunar Module Pilot)

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

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Joseph J. Adamski

7th edition

978-1111825911, 1111825912, 978-1133684374, 1133684378, 978-111182591

More Books

Students also viewed these Databases questions

Question

How prepared was the organization for the new business strategy?

Answered: 1 week ago