A practice relational database built in PostgreSQL modeling the universe (galaxies, stars, planets, and moons) with full foreign key relationships :) - this is a school related certification project
| Table | Rows | Description |
|---|---|---|
| galaxy | 6 | big galaxies, each star belongs to one |
| star | 6 | stars that anchor their own planetary systems |
| planet | 12 | planets orbiting stars, from earth to exoplanets |
| moon | 21 | moons tied to their planets |
| comet | 3 | standalone, no foreign key. no allegiance |
- postgreSQL
- clone the repo:
git clone https://github.com/cassmcxi/postgresql-universe-database.git - create the database:
createdb universe - run the file:
psql universe < universe.sql
