Ignore:
Timestamp:
09/11/26 11:05:54 (3 weeks ago)
Author:
Stefan <trsunovstefan@…>
Branches:
main
Children:
9577c79
Parents:
fe28254
Message:

Zip files

File:
1 edited

Legend:

Unmodified
Added
Removed
  • docs/P2-RelationalDesign/RelationalDesign.md

    rfe28254 rdf05838  
    9696![relational_schema](relational_schema.jpg)
    9797
    98 Generated in **DBeaver** from the **live** `project` schema, in crow's-foot
     98Generated in **Pgadmin** from the **live** `project` schema, in crow's-foot
    9999notation — not drawn by hand, so it is evidence that the deployed database
    100100actually matches the design described above. Each box is a table with its
    … …  
    103103
    104104### 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 of
    112    [`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 ```sh
    118 flatpak remote-add --if-not-exists --user flathub https://dl.flathub.org/repo/flathub.flatpakrepo
    119 flatpak install --user flathub io.dbeaver.DBeaverCommunity
    120 # or:  sudo snap install dbeaver-ce
    121 ```
    122105
    123106**With pgAdmin 4**, if DBeaver is unavailable — it reads the live schema the same
    … …  
    131114   `convert relational_schema.png relational_schema.jpg`
    132115
    133 Whichever tool is used, state it here so the choice is explicit rather than
    134 inferred. Do **not** substitute a tool that only reads the `.sql` file — such as
    135 dbdiagram.io — because the diagram would then show what the script says rather
    136 than what the deployed database contains, which is the thing this artefact is
    137 meant to demonstrate.
Note: See TracChangeset for help on using the changeset viewer.