Exercise 14: Space Exploration

erDiagram

    mission {
      string title
      string objective
      datetime start_date
      datetime end_date
      decimal budget
      int key PK "id_mission"
      int id_mission_state FK "id_mission_state"
      int id_spacecraft FK "id_spacecraft"
    }

    astronaut {
      string name
      datetime birth_date
      int key PK "id_astronaut"
      int id_nationality FK "id_nationality"
    }

    nationality {
      string name
      string label
      string uuid
      int key PK "id_nationality"
    }

    mission_astronaut {
      int cost
      int key PK "id_mission_astronaut"
      int id_mission FK "id_mission"
      int id_astronaut FK "id_astronaut"
    }

    spacecraft{
      string name
      string type
      int used
      int key PK "id_spacecraft"
    }

    mission_state {
      string name
      string label
      string uuid
      int key PK "id_mission_state"
    }

    nationality one--many astronaut : is
    spacecraft one--many mission : uses
    astronaut one--many mission_astronaut : leads
    mission one--many mission_astronaut : has
    mission_state one--many mission : has

Description #

• The property “name” in the table “mission_state” can have the values: “Planned”, “Active”, “Completed”, “Canceled”.

• This app manages space missions by tracking details such as mission objectives, budget, dates, and spacecraft. It stores astronaut profiles, including their nationality, and assigns them to specific missions. The app also monitors the usage of spacecraft and the current status of missions (e.g., planned, in progress, or completed).

• In entities “mission_state” and “nationality”, name represents the state that will be displayed on the screen, label represents the value that programmer will use to filter the states, and the uuid represents a value to distinguish the states.

• OBS: The value of the field “uuid” is generated automatically.

Tasks #

• astronaut/mission/spacecraft/mission_state/mission_astronaut/nationality: Add, Edit, Delete.

  • When the mission is created, it will automatically become “Planned”.
  • When a spacecraft is created, it will automatically set property “used” with value 0 (false), meaning that it is not used in any mission yet.
  • The field “Mission state” from entity “mission” will be read-only in edit view.

• Create catalogs for entities: “mission_state”, “spacecraft”, “nationality”, “astronaut” and “mission”.

• Create event listeners for tables that needs validations (e.g., adding an astronaut without a name, mission without title, etc., should not be allowed).

• Add a new entity action at the mission level “Initiate mission”:

  • First check if the mission has already been initiated (it has the “Active” status), if it does → validation message;
  • A mission must have at least one astronaut, if it doesn’t → validation message;
  • After the initiation of the mission, the state will change from “Planned” → “Active”;
  • The value of property “used” will become 1 (true);
  • If the mission is initiated and the spacecraft selected for it has its used property set to 1 (meaning it’s already in use by another mission) → validation message.

• Add a new entity action at the mission level “Cancel mission”, that will change the mission status to “Canceled”:

  • A mission cannot be canceled if it is in the “Completed” state → validation message.
  • A mission cannot be canceled if it is already in the “Canceled” state → validation message.

• Add a new entity action at the mission level “Complete mission”:

  • It can’t be completed if it is in the “Planned” state;
  • It can’t be completed if it is in the “Canceled” state;
  • It can’t be completed if it is already in the “Completed” state;
  • It will set the property “used” from spacecraft that utilizes to 0 (meaning is free to use).

• Astronaut report: mission situation at astronaut level (total number of missions, budget value).

• Spacecraft report: mission situation at spacecraft level (total number of missions, budget value).

• Mission report: astronaut situation at mission level ( total number of astronauts, budget value).