Draw an ER diagram to describe the following situation. Make the diagram as complete as possible, including attributes and cardinality constraints. Explain/justify your decisions as needed. You do not need to make an entity/attribute list.
Strategic Virtual Worlds (SVW) is a game development company interested in creating combat-style games for virtual environments. The virtual environment of the game is made up of regions which are connected to each other in a map-like topology. Each region has at least 4 neighbors, one to the north, south, east, and west. (No, this will not create an infinite map.) Regions may also have direct connections to other arbitrary regions through the use of a "teleportation" or "warp" mechanism. Such regions are also considered to be neighbors. Regions have unique identifying numbers, a terrain type, a population count, and a weather status.
The game has users, who each have a unique login name, a screen name, and a small set of e-mail addresses.
Users can own estates. Estates are groups of regions. Each region can belong to only one estate. Each estate is owned by one user, but a user can own many estates. Estates have a unique identification code and timestamps indicating when the estate was 1) created and 2) last modified.