Relational Databases: Build a Celestial Bodies Database

Hi,
Please help me resolve these issues. The following tasks are not completing.
The tests keeps failing despite the sql appearing correct.

Each “planet” should have a foreign key that references one of the rows in star

Each “moon” should have a foreign key that references one of the rows in planet

The planet and moon table all show their foreign keys when viewed in the terminal. Here is the gitpod snapshot link:
https://gitpod.io#snapshot/f96fc88e-326a-4752-82df-e95f000fdd95

Help me fix this thanks!

do you have rows in the planet and moon tables?

Yes I have,
There are 20 rows in moon and 12 rows in planet. Here are the table details for both tables shown in the images below:

in the planet table, what are the values in the star_id column?

1 Like

Thanks for the hint. I populated all the tables with the appropriate data respecting the foreign keys and everything worked perfectly.
I really appreciate your advice. I hope you will be with me right up to the end!