Entity-Relationship Model AI Usage
Name of AI service/solution that was used
ChatGPT
URL:
Type of service/subscription:
ChatGPT Plus subscription
Final result
Diagram:
The final entity-relationship diagram was created and edited manually in TerraER. The final diagram files are attached on the ERModel page as ERModel_v02.xml and ERModel_v02.png.
Model description:
AI was used only as assistance for reviewing the model structure, checking whether the documentation follows the Phase P1 instructions, and improving the textual explanation of the entities, relationships, cardinalities, participation constraints, candidate keys, and attributes.
The final ER model contains the following entity sets:
- Buildings
- Rooms
- Equipment
- RoomEquipment
- Users
- Reservations
- ReservationEquipment
- Approvals
The final model supports reservations that may include a room, equipment, or both. Equipment can be assigned to specific rooms through RoomEquipment, and equipment that is requested as part of a reservation is represented through ReservationEquipment.
Entire AI usage log
- Prompt:
I am working on Phase P1 of a Databases course project called Room Reservation System. I need to check whether my ER model follows the official Phase P1 instructions.
Response summary:
The AI helped review whether the ER model contained appropriate entities, relationships, candidate keys, primary keys, attributes, cardinalities, and participation constraints.
- Prompt:
The professor suggested that the model should support equipment in rooms, equipment in general stock, and reservations for a room, equipment, or both. How should I update the model?
Response summary:
The AI suggested adding stock_quantity to Equipment and adding an associative entity named ReservationEquipment to represent equipment requested as part of a reservation. It also suggested changing the room-reservation relationship so that a reservation may include a room but does not have to.
- Prompt:
Check whether the updated TerraER model is conceptually correct before exporting it.
Response summary:
The AI helped check the updated model and suggested corrections related to optional participation and numeric data types for quantity attributes.
- Prompt:
Rewrite the ERModel wiki documentation according to the corrected v.02 model.
Response summary:
The AI helped prepare the textual documentation for the ERModel wiki page, including updated entity descriptions, relationship descriptions, design assumptions, and model history.
