COP-5725—Group-Project

# loading packages 
library(rmarkdown)
library(knitr)

# INTRODUCTION

Introduction will go here

0.1 Example ER Diagram under Quarto diagrams

1 PHASE 1 AND 2

Started ideas on a D&D Entities and relationships

List of Entities

• Entities
  • Players
  • Characters
  • Classes
  • Races
  • Alignments
  • Spells
  • Monsters
  • Bosses
  • NPCs
  • Equipment
  • Events
  • Achievments
  • Sales
  • Trades
  • potions
  • weapons
  • Armor
  • PVP
  • locations
• possible quires
  • find what bosses character killed and get list of items from that boss he traded to another character
  • find what event(quest) gets the most exp with a sword or wand as reward that can only be used my mages and paladins

erDiagram
    User{
         int ID PK
         varchar FirstName
         varchar LastName
         varchar Email
    }
    Character{
        int ID PK
        int userID FK
        varchar Name
        int Level
        int classID FK
        int XP
        int raceACE FK
        int HP
        int mana
        int allignmentID FK
    }
    Allignment{
        int ID PK
        varchar(50) Name  
    }
    Class{
        int ID PK
        varchar(50) Name
        int HitDie
        text Description
    }
    Spell{
        int  ID
        varchar Name
        int  Level
        text Effect
        int  CastingTime
        int  Duration
    }

erDiagram
    Monsters{
        varchar ID PK
        varchar Name
        float CR
        int HP
        int AC
        varchar createType
        int XP
    }
    Bosses{
        int ID PK
        varchar Name
        int monsterID FK
        varchar Lair
    }
    NPC{
        int ID PK
        varchar Name
        varchar Role
        varchar Faction
        varchar Location
    }
    Equipment{
        int ID PK
        varchar Name
        varchar type
        varchar bonus
        varchar rarity
        text    Description
    }

erDiagram
    Events{
        int ID PK
        varchar Name
        varchar Description
    }
    Achievments{
        int ID PK
        varchar tName
        text Description
        int  xpReward
    }

2 PHASE 3

2.1 Specification of the Entity

2.2 Cardinality and Participation Ratio

2.3 Strong and Weak Entities

2.4 Supertype and Subtype

2.5 Table and Columns Constraints

2.6 Normalization

3 PHASE 4

3.1 Implementation of ER Diagrams in MYSQL

4 QUERIES AND OUTPUTS

5 REVERSE ENGINEERING DIAGRAM