Astro Database

This repository contains the schema and sample data for an astronomy-related database named "Astro.db".

Overview

The "Astro.db" database is designed to store information about various astronomical objects such as galaxies, star systems, planets, moons, asteroids, comets, probes, and more. It includes tables for storing general attributes, orbital information, physical characteristics, electromagnetic spectrum data, discovery details, and more.

Tables

• Galaxies: Stores information about galaxies.
• StarSystems: Stores information about star systems.
• Planets: Stores information about planets.
• Moons: Stores information about moons.
• Asteroids: Stores information about asteroids.
• Comets: Stores information about comets.
• ProbesAndSatellites: Stores information about probes and satellites.
• NeutronStars: Stores information about neutron stars.
• Nebulas: Stores information about nebulas.
• BlackHoles: Stores information about black holes.
• SuperNovas: Stores information about supernovas.
• WhiteDwarfs: Stores information about white dwarfs.
• DwarfPlanets: Stores information about dwarf planets.
• AstroObjectCategory: Stores categories of astronomical objects.
• OrbitalInformation: Stores orbital information about planets.
• LocationAndVisibility: Stores information about the visibility of astronomical objects.
• InformationOfDiscovery: Stores details about the discovery of astronomical objects.
• ChemicalComposition: Stores chemical composition information.
• PhysicalAttributes: Stores physical attributes of astronomical objects.
• EMSpectrumInformation: Stores electromagnetic spectrum information.
• GeneralInformation: Stores general information about astronomical objects.

Views

• PlanetLocationAndVisibility: Provides information about the location and visibility of planets.
• PlaneteryAndOrbitalAttributes: Provides orbital and physical attributes of planets.
• PlanetEMS: Provides electromagnetic spectrum and chemical composition information of planets.

Sample Data

The repository includes sample data inserts for various astronomical objects.

Usage

To use the "Astro.db" database, you can clone this repository and import the schema and sample data into your preferred database management system. You can then query the database to retrieve information about astronomical objects.

License

This project is licensed under the MIT License - see the LICENSE file for details.