Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help with a conceptual design (ERD - Entity Relationship Diagram) out from the rules stated. Here is the story: Here is the extracted entities

Please help with a conceptual design (ERD - Entity Relationship Diagram) out from the rules stated.

Here is the story:

image text in transcribed

Here is the extracted entities and 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.

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 I JUST NOW NEED THE DIAGRAM FOR THIS CONCEPT, SAMPLE IS BELOW

Humans and demons have been engaged in war for more than a millenium. These wars take place inside the castles of the demon king himself. The castle's location in every war is picked at random, but it is important to note that the wars taking place in the 69th and 143th millennium both occurred at Avos, Dilhevia. This castle only appears when the sun has set and a specific temperature is reached. The humans are an organized group, following the ideal that the strength of many is greater than the strength of one. They are divided into three different classes, which are the mage, the knight, and of course the hero. Every time one of each class falls, another steps up to take his place. Every human has a first name and a last name. It is a strict practice in the human realm to make sure the first names are not repeated to give honor to their fallen, hence examples of legendary heroes looked up to are Misha123, Sasha6969, and many more. Every mage has a favorite spell, the same way every knight has a favorite weapon. Every mage casts multiple spells, like how each knight can use several weapons. All spells have at least one mage who knows how to cast them, the same way all weapons have at least one specialized knight to wield them. The great thing about spells is that they are used to amplify the effect of other spells when used in conjunction. Last but definitely not least, the hero is dedicated to protecting all humans excluding himself. For this reason he has seven sources which represent his seven lives. The sources of each hero may vary from one to the next. The demon king together with his descendants compose the demon race. There's a lot of discussion regarding how he came to be, but the most popular theory is that the demon king spawned himself at around 1800 BC. He is very meticulous in the sense that he takes large intervals of time before spawning the next descendant. Because of this, each descendant is able to wield multiple weapons, to make them even more overpowered, they can also cast multiple spells. Furthermore, every spell is cast by more than one descendant, and every weapon wielded by more than one as well. The descendants are indeed juggernauts of destruction. Each time the demon king is slain, he is resurrected by his descendants making the cycle continue on. They are able to do this due to the demon king having one and only one source which varies in each of his resurrections. The demon king's name is the same in every resurrection

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Graph Database Modeling With Neo4j

Authors: Ajit Singh

2nd Edition

B0BDWT2XLR, 979-8351798783

More Books

Students also viewed these Databases questions