Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
2. The table constellation
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.