Legends of the Balkans - Relational Design

Signs

Below are the annotations used in the relational schema:

• * (asterisk) → Denotes a Primary Key.
• # (hash) → Denotes a Foreign Key.
• (A, B, C) → Represents the attributes within a table.
• [ ] → Represents optional fields (nullable).

Tables

Full list of tables:

• Player (*PlayerID, Username, Email, Password)
• Character (*CharacterID, #PlayerID, Name, Health, EXP, Gold)
• Faction (*FactionID, Name, Description)
• Reputation (*#CharacterID, *#FactionID, ReputationPoints, Rank)
• Quest (*QuestID, Name, EXP_Required, EXP_Reward, Gold_Reward)
• Item (*ItemID, Name, Type, Rarity, Craftable)
• Enemy (*EnemyID, Name, Health, Damage, LootDrop)
• Trader (*TraderID, Name, Type)
• Market (*MarketID, #ItemID, #SellerID, Price)
• Guild (*GuildID, Name, #LeaderID)
• Character_Quest (*#CharacterID, *#QuestID)
• Character_Item (*#CharacterID, *#ItemID)
• Enemy_Item (*#EnemyID, *#ItemID)
• Trader_Item (*#TraderID, *#ItemID)
• Character_Guild (*#CharacterID, *#GuildID)

DDL Script

The Data Definition Language (DDL) script defines the database schema. The SQL file will be attached here:

[[Attachment:lotb_ddl.sql]]

DML Script

The Data Manipulation Language (DML) script contains sample data insertions. The SQL file will be attached here:

[[Attachment:lotb_dml.sql]]

Relational Diagram

The relational schema diagram will be placed here: