Conceptual Data Model

Instructions for the AirGalaxy Conceptual Data Model (CDM)

Objective: Design a simplified CDM for the AirGalaxy application.

1. Entities and Attributes:

   • Rocket:
     • “Reference number”: unique number assigned to each rocket.
     • “Name”: the rocket’s name.
     • “Type”: the rocket model.
   • User:
     • “Login”: username.
     • “Email”: the user’s email address.
     • “Role”: the user’s role, (e.g., “Admin”, “Operator”).
   • Anomaly:
     • “Description”: description of the anomaly.
     • “Date and time”: when the anomaly was detected.
   • Notification:
     • “Message”: content of the notification message.
     • “Date sent”: date when the notification was sent.

2. Relationships and Cardinalities:

   • User and Rocket: “Launches” relationship. One user can launch multiple rockets, but a rocket can only be launched by a single user.
   • Rocket and Anomaly: “Detects” relationship. One rocket can have multiple anomalies, but a single anomaly can be linked to just one rocket.
   • Anomaly and Notification: “Triggers” relationship. One anomaly can trigger several notifications, but a single notification is triggered by an individual anomaly.
   • User and Notification: “Receives” relationship. A single user might receive several notifications, and the same notification might be sent to several users.

3. Design:

   • Draw entities as rectangles, indicating their attributes inside the rectangle.
   • Link the entities together based on the relationships and cardinalities described above.
   • Ensure that the CDM is clear and that all relationships are correctly specified.

https://imgr.whimsical.com/object/DSjzBpBH7Yy15FmZY7SZ5W