A comprehensive relational database designed to store, manage, and analyze information regarding elements of the cosmos and modern space infrastructure.
- Contains the Entity-Relationship Diagram (ERD) detailing the schema and structural architecture of the database.
- Includes Data Definition Language (DDL) scripts responsible for setting up the database foundations, defining tables, and inserting the initial dataset.
A collection of SQL queries designed for practical business and scientific analysis. Key highlights include:
- Query 4: A comparative analysis to determine the most dense celestial bodies in the database.
- Query 8: A mathematical proof of Kepler's Third Law of Planetary Motion using the stored astronomical records.
- Demonstrates the implementation of database transactions. This section includes a deep analysis and justification for selecting specific transaction isolation levels to ensure data integrity and prevent concurrency issues.