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. Make sure to remove all redundant relationships. Humans and

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

image text in transcribed

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_2

Step: 3

blur-text-image_3

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

Database In Depth Relational Theory For Practitioners

Authors: C.J. Date

1st Edition

0596100124, 978-0596100124

More Books

Students also viewed these Databases questions