Description
Create ER Diagram with the following information:
Gamer -user name, password, email, first name and last name; User name is unique; Can create multiple characters
Character -name is unique. Needs to show current level, exp points, health points, magic points, strength, intelligence, dexterity, belong ONLY ONE class. 3 classes: warrior, mage, ranger
Items (for character)- name, type, value, status (0 to 100, 100 is new and 0 is broken), 3 Items (weapon, armor, accessory) Many Character can have the same item of same name, but not same individual item
Weapon – type, speed, damage
Armor – defense value, type
Accessory – type, special effect
Character Skill – name, Magic Point cost of skill, level requirement, description (multiple characters can have same skill and can have multiple skills) (Some skills have prereqs)
Player vs Player – each match has: score of each character, list of match history (only 2 players in match)
Guild – name of guild, time created, current status, list of characters in guild
Reviews
There are no reviews yet.