Celestial Bodies Database (PostgreSQL)

This project is part of the freeCodeCamp Relational Databases Certification.
It demonstrates the design and implementation of a normalized relational database using PostgreSQL.

Project Overview

The database models a simplified astronomical system with related entities:

• Galaxies
• Stars
• Planets
• Moons
• Comets

Each entity is stored in its own table with appropriate primary and foreign key relationships.

Key Concepts & Skills

• Relational database design
• PostgreSQL & SQL
• Primary and foreign keys
• One-to-many relationships
• Data normalization
• Data types and constraints
• Writing and exporting SQL database schemas

Database Structure

• galaxy → stores galaxy-level information
• star → each star belongs to a galaxy
• planet → each planet orbits a star
• moon → each moon orbits a planet
• comet → stores additional astronomical objects

Files

• universe.sql — SQL dump containing table definitions and sample data

How to Rebuild the Database

psql -U postgres < universe.sql