Changes between Version 3 and Version 4 of conceptual-model

Timestamp:

02/13/25 19:29:22 (9 days ago)

Author:

181557

Comment:

--

conceptual-model

@@ -2 +2 @@
 
 == Entity Relationship Diagram ==
-[[Image(lotb_erd.png)]]
+[[Image(lotb_erdiagram.png)]]
 
 == Data Requirements ==
@@ -27 +27 @@
   - `Name`
   - `Description`
+
+- **Reputation**: Tracks character reputation with different factions.
+  - `CharacterID` (Foreign Key → Character)
+  - `FactionID` (Foreign Key → Faction)
+  - `ReputationPoints`
+  - `Rank`
 
 - **Quest**: Missions that characters can complete.
@@ -54 +60 @@
   - `Type`
 
-- **Market**: A system where players can list items for sale.
+- **Market**: A system where players can list and sell items.
   - `MarketID` (Primary Key)
   - `ItemID` (Foreign Key → Item)
@@ -65 +71 @@
   - `LeaderID` (Foreign Key → Player)
 
-=== Relations ===
-Below are the key relationships between entities:
+== Relations ==
 
-- **Lists** (Market, Character, Item):  
-  The Market entity represents a listing relationship where a Character lists an Item for sale.  
-  *Cardinality*: One Character may list many Items via Market; each Market listing is associated with one Item.
+=== 1-1 Relations ===
+- `Guild.LeaderID` → `Player.PlayerID`: A guild has a single leader, who is a player.
 
-- **Drops** (Enemy, Item):  
-  An Enemy drops one or more Items.  
-  *Cardinality*: An Enemy can drop multiple Items; an Item may be dropped by multiple Enemies.
+=== 1-N Relations ===
+- `Character.PlayerID` → `Player.PlayerID`: A player can have multiple characters.
+- `Character.FactionID` → `Faction.FactionID`: A character belongs to one faction.
+- `Market.SellerID` → `Player.PlayerID`: A player can list multiple items on the market.
 
-- **Sells** (Trader, Item):  
-  A Trader sells one or more Items.  
-  *Cardinality*: A Trader can sell many Items; an Item can be sold by multiple Traders.
-
-- **ReputationIn** (Faction, Character):  
-  This relationship captures a Character’s reputation within a Faction, with attributes such as `ReputationPoints` and `Rank`.  
-  *Cardinality*: A Character can have reputation in multiple Factions; a Faction can record reputation for multiple Characters.
-
-- **Completes** (Quest, Character):  
-  A Character can complete one or more Quests.  
-  *Cardinality*: A Character may complete many Quests; a Quest can be completed by multiple Characters.
-
-- **Owns** (Player, Character):  
-  A Player owns one or more Characters.  
-  *Cardinality*: One Player may own many Characters, while each Character is owned by a single Player.
-
-- **IsMember** (Guild, Character):  
-  This membership relationship indicates that a Character is a member of a Guild.  
-  *Cardinality*: A Character can be a member of multiple Guilds; a Guild can have many Characters as members.
+=== N-N Relations ===
+- `ReputationIn(CharacterID, FactionID)`: A character can have reputation with multiple factions, and factions can have multiple characters.
+- `Completes(CharacterID, QuestID)`: A character can accept multiple quests, and quests can be taken by multiple characters.
+- `Owns(CharacterID, ItemID)`: A character can own multiple items, and items can belong to multiple characters.
+- `Drops(EnemyID, ItemID)`: Enemies can drop multiple items, and items can be dropped by multiple enemies.
+- `Sells(TraderID, ItemID)`: Traders can sell multiple items, and items can be sold by multiple traders.
+- `IsMember(CharacterID, GuildID, Role)`: A character can join a guild, and a guild can have multiple members. The `Role` attribute defines if the character is a "Leader" or "Member" in the guild.