Changeset df05838 for docs/P2-RelationalDesign/RelationalDesign.md
- Timestamp:
- 09/11/26 11:05:54 (3 weeks ago)
- Branches:
- main
- Children:
- 9577c79
- Parents:
- fe28254
- File:
-
- 1 edited
-
docs/P2-RelationalDesign/RelationalDesign.md (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
docs/P2-RelationalDesign/RelationalDesign.md
rfe28254 rdf05838 96 96  97 97 98 Generated in ** DBeaver** from the **live** `project` schema, in crow's-foot98 Generated in **Pgadmin** from the **live** `project` schema, in crow's-foot 99 99 notation — not drawn by hand, so it is evidence that the deployed database 100 100 actually matches the design described above. Each box is a table with its … … 103 103 104 104 ### How to regenerate it 105 106 **With DBeaver** (the tool the course recommends):107 108 1. Connect to the assigned FINKI PostgreSQL project database.109 2. Double-click the `project` schema → **ER Diagram** tab.110 3. Right-click in the diagram → **Notation** → **Crow's foot**.111 4. Arrange the tables to mirror the layout of112 [`ERModel_v01.png`](../P1-ConceptualModel/ERModel_v01.png).113 5. Right-click → **Export diagram** → save as `relational_schema.jpg`.114 115 On Linux, install it with:116 117 ```sh118 flatpak remote-add --if-not-exists --user flathub https://dl.flathub.org/repo/flathub.flatpakrepo119 flatpak install --user flathub io.dbeaver.DBeaverCommunity120 # or: sudo snap install dbeaver-ce121 ```122 105 123 106 **With pgAdmin 4**, if DBeaver is unavailable — it reads the live schema the same … … 131 114 `convert relational_schema.png relational_schema.jpg` 132 115 133 Whichever tool is used, state it here so the choice is explicit rather than134 inferred. Do **not** substitute a tool that only reads the `.sql` file — such as135 dbdiagram.io — because the diagram would then show what the script says rather136 than what the deployed database contains, which is the thing this artefact is137 meant to demonstrate.
Note:
See TracChangeset
for help on using the changeset viewer.
