Consider the following scenario:

A gaming company requires a database for a new game that they are developing. The game will be single player open world environment. The database will provide data for items and characters within the current scene or location within the games open world.

The database will have multiple entities, including non$-$player$-$characters $($NPC$),$ a single player$-$character, statistics $($stats$),$ items and game$\_$state. Consider this is a simplified model, it will not need to be extensively designed beyond these components.

For clarity, all players and NPCs will have both stats and a location and can be considered characters. Players can have items. Items will have stats and a description. Game$\_$state may have a default set of attributes, but will also need a player$-$game with unique attributes for the players progression through the game.

a$)$ Your first task is to construct an Entity$-$Relationship diagram $($ERD$)$ that captures entities and their relationships. You are free to make assumptions about any information that you believe is not supplied as long as you state these assumptions. $($Your assumptions should not contradict the description!$)$

b$)$ Secondly, construct an Enhanced Entity$-$Relationship diagram $($E$-$ERD$)$ version of your ERD. Once again, you can make any assumptions about information that has not been provided, providing it doesn't contradict. Consider entities that share attributes or connect to similar entities.