note

【ChatGPT】ER図を作成

今回は、ChatGPTを用いてER図(ERD)の作成を行ってみます ER図（Entity Relationship Diagram）とはエンティティとリレーションを図示したものです 前回の様にChatGPTでテーブル定義を行い、そこからER図を作成します ※前回とは別のテーブル定義です (社員マスタ、部署 ...
GitHub

dayoonsuh/Entity-Relationship-Diagram-Detection

ERD clustering tool allowing database/data science instructors and TAs to cluster ERD (Entity Relationship Diagram) submissions. Given a test set of ERD diagram images and a ground truth, we created ...
dbta

Only the Strong Survive

In building a logical data model, some entities are considered strong, other entities are considered weak. Strong entities are the most foundational elements within a nascent Entity-Relationship ...
dbta

Don’t Do the Too-Many-Foreign-Keys Thing!

Occasionally one sees an entity-relationship diagram (ERD) having an unusual characteristic. The unusual element is an entity (or more than one) that seems to have a relationship with every other ...
GitHub

ERD-Normalization-Best-Practice

• Jika Entity yang akan berelasi dengan Entity lain memiliki persamaan nilai Attribute Key, maka bisa digunakan sebagai acuan bersama. • Namun jika pada kasusnya Attribute Key berbeda / independen ...