Resolve tasks and learn about the cosmos
Instruction
Our database is called cosmos and consists of two tables, constellation and star.
The night sky has many constellations, or groups of stars that make a shape or pattern. The picture below shows one such constellation:
This is the Andromeda constellation, named after a princess in a Greek myth. Now that you know what a constellation is, let's look at the constellation table.
Exercise
The constellation table contains the following columns:
id– A unique identifier for that constellation.name– The official name of that constellation.area– The area of the constellation, in square degrees.count_main_stars– The number of main stars in the constellation.
Explore the content of this table by selecting all its data.
