Database ER Diagram for Video Game Company Free Download (PNG)

 

Table Explanations

Superhero

This is the main list of superheroes. It has their superhero name, full name/real name, a list of IDs linking to other tables, and their height in centimeters and weight in kilograms.

Gender

The Gender table lists three rows: Male, Female, and N/A.

Color

The Color table contains references for eye color, skin color, and hair color. The table also contains a row that indicates no color

Race

The table shows values for the different races of superheroes, such as Human.

Publisher

The Publisher table lists all of the publishers such as DC and Marvel.

Alignment

The table shows three values that demonstrate how the superhero is aligned: Good, Neutral, and Bad.

Attribute

The table lists six different attributes (e.g. intelligence) that can describe a superhero.

Hero Attribute

The table is the intersection of attributes and superheroes. A superhero can have multiple attributes, and for each attribute, they have a value from 0-100% indicating their rating.

Superpower

The superpower table lists all of the available abilities or superpowers that a character can possess in a given type of game.

Hero Power

Download Click here

The table lists the IDs of each power that each superhero can have because a superhero can have more than one superpower.


No comments:

Post a Comment