Please help

Assignment 5 Use the sample solution to assignment 4 (below) as the conceptual model, develop a logical model (relational mod

Assignment 5 Use the sample solution to assignment 4 (below) as the conceptual model, develop a logical model (relational model) based on it. Specify all the integrity constraints in English -Acquires- Character Gamer sharacter name. Item PK PK username PK tem name level O-Owns-O Creates- password first name last name experience value status tуре health points mana points strength intelligence email Skill dex PK skill id class name PvP Match MP cost level required PK MatchID description Winner Names Loser Name Prerequisite Kill Time Kill Score type Belongs to- Guild Accessory Armor Weapon PK guild name time founded status defense tуpe special effects speed damage per second armor type ASSUMPTIONS A gamer has to create at least one character to be stored in the database Item name is unique for each item Characters do not always have to be carrying an item There could be items that do not belong to any character Characters do not always have skills A character does not have to be in a guild A character can be a member of many guilds



Source link

Leave a Reply

Your email address will not be published. Required fields are marked *