Please help with a conceptual design (ERD - Entity Relationship Diagram) out from the rules stated. Make sure to remove all redundant relationships.

Entities:

Human Mage Knight Hero Spell Weapon Demon Demon King Source

Relationships:

Human has a first name and a last name. Mage has a favorite spell. Knight has a favorite weapon. Every mage knows how to cast multiple spells. Every knight can use multiple weapons. Every spell is known by at least one mage. Every weapon is wielded by at least one specialized knight. Human is divided into three classes: mage, knight, and hero. Hero is dedicated to protecting all humans excluding himself. Hero has seven sources. Demon King and his descendants compose the demon race. Each descendant can wield multiple weapons. Each descendant can cast multiple spells. Each spell is cast by more than one descendant. Each weapon is wielded by more than one descendant. Demon King has one and only one source in each resurrection. Demon King's name is the same in every resurrection. Please note that the ERD is a conceptual design and you may need to add more attributes to it depending on the specific use case.

POSSIBLE ERD:

Humans -First Name -Last Name -Class

Mages -First Name -Last Name -Class -Favorite Spell

Knights -First Name -Last Name -Class -Favorite Weapon

Hero -First Name -Last Name -Class -Sources

Demons -Name -Source

Spells -Mages -Descendants

Weapons -Knights -Descendants SAMPLE OF ERD IS BELOW

\begin{tabular}{|l|l|} \hline \multicolumn{2}{|c|}{ tblHIRE_RATES } \\ \hline PK & hire_rate id \\ \hline & hire_rate_rate hire_rate_period \\ \hline \end{tabular}