Entities and their attributes: Player Attributes: PlayerID (Primary Key), Username Character Attributes: CharacterID (Primary Key), PlayerID (Foreign
No answer yet for this question.
Ask a Tutor
Question:
Entities and their attributes:
Player
- Attributes: PlayerID (Primary Key), Username
Character
- Attributes: CharacterID (Primary Key), PlayerID (Foreign Key), CharacterName, Team, SkillLevel
Inventory
- Attributes: InventoryID (Primary Key), CharacterID (Foreign Key), ItemID (Foreign Key), Quantity, SlotNumber
Item
- Attributes: ItemID (Primary Key), ItemName, ItemType, Description
ErrorLog
- Attributes: LogID (Primary Key), AccountID (Foreign Key), ErrorType, Timestamp, Description
Relationships:
- Player to Character: One-to-Many relationship (A player can have multiple characters).
- Character to Inventory: One-to-Many relationship (A character can have multiple items in their inventory).
- Item to Inventory: Many-to-Many relationship (Multiple characters can have the same item in their inventory).
- Player to ErrorLog: One-to-Many relationship (A player can have multiple error logs).
DRAW ER DIAGRAM FROM THE INFORMATION ABOVE
Related Book For
Modern Systems Analysis And Design
ISBN: 9780134204925
8th Edition
Authors: Joseph Valacich, Joey George
Posted Date: