This report provides a comprehensive analysis of database systems, focusing on the design and implementation of a database for the International Space Station (ISS). It begins with a justification for using an SQL database, explaining its suitability for storing mission, agency, and equipment details in a tabular format. The report then contrasts relational and NoSQL database approaches, highlighting their differences in structure, scalability, and query languages, and explains why NoSQL is less appropriate for this scenario. It then addresses database normalization, transforming a flat table into the third normal form (3NF) to eliminate data redundancy. The detailed implementation process includes identifying attributes, specifying data types, and creating an Entity-Relationship Diagram (ERD). The report provides SQL commands to create and populate tables for mission information, equipment, and agency details, and concludes with a poster analysis on a Kaggle dataset related to the Novel Coronavirus 2019.
![[object Object]](/_next/static/media/star-bottom.7253800d.svg)
