FORM AN ERD DIAGRAM

DO NOT WRITE ANY CODE

FIGHTER'S LEGACY

"Fighter's Legacy" is a world$-$famous video game series by Legacy Studios. Legacy Studios is

planning to make a separate website for Fighter's Legacy. Your task is to design an ERD for

efficiently storing Fighter's Legacy information in the Fighter's Legacy Website Database. Each

Fighter's Legacy game is uniquely identified by its name $($FL$9,$ FLX$,$ FL$11,$ FL$1,$ etc.$)$ and can be

played on PlayStation, PC$,$ Xbox, or Nintendo. Fighter's Legacy is famous for its exciting

characters, smooth and brutal fights, and its engaging and deep story mode. Each character has a

name, different modes $($e$.$g$.,$ Thunder Lord Zeus, Queen Mira, etc.$),$ the world to which it

belongs $($i$.$e$.,$ SkyRealm, EarthLands, or DarkRealm$),$ and a set of special moves. Fighter's

Legacy has different modes like Single Player, Classic Towers, Story mode, and Customize. The

single$-$player mode is the simplest of all, in which two different or the same characters fight with

each other in a selected battleground. Each battleground has a unique name, location, and

artifacts. A fight is played in a battleground and consists of a fixed time, a winner, and a loser.

The story mode can be of one or more parts, each part has different chapters, cutscenes, and

fights. Fighter's Legacy stories revolve around three major worlds, namely SkyRealm,

EarthLands, and DarkRealm. Each world has its own ruler, which is also a character, and

different battlegrounds. Each chapter has a unique name and number, a chapter is played by one

character and in different worlds. A chapter has many cutscenes and fights. Cutscenes consist of

audio, video, and subtitles. Each character has a set of special moves. Special moves have

different categories $($LegacyMove$,$ Classic, Fatal Strike, Brutal Finish, etc.$),$ and each move has a

unique name and a specific pattern $($order of keys$)$ to perform the move. For the Classic Towers,

characters play different games $($e$.$g$.,$ Test Your Will, Test Your Strength, etc.$),$ and these games

have their rules, specific times, and artifacts. In Customize mode, players can modify characters

by adding new skins, new moves, and new accessories. This was the game$-$specific part of

Fighter's Legacy. There are some website$-$specific features, and you have to keep a record of

them as well in the database. The Fighter's Legacy website will be collaborating with E$-$Sports to

host Fighter's Legacy Tournaments. The Fighter's Legacy website frequently launches DLC

$($Downloadable Content$).$ DLC includes Official Legacy Studios and limited$-$edition packages. A

DLC package consists of new moves, costumes, and maybe new characters as well. Players can

buy these packages to customize their characters. Each Fighter's Legacy game is launched in

three game$-$buying packages, each package has a name, the features it includes, and the platform

for which this package is bought. Note: Game$-$buying packages are different from DLC

packages, and the website stores information on how many copies of each package are sold and

the buyer's name. In each E$-$Sports Tournament, players from around the world participate. The

Fighter's Legacy website stores the start date of the Tournament, the number of players

participating, the number of rounds, the winner and runner$-$up of the tournament, and the day of

the final fight of the Tournament. Each round of the Tournament consists of different fights, and

each round has its winner and runner$-$up$.$ Note: Fighter's Legacy is a world$-$famous game, and

players are increasing every day, which means more and more data is coming. Your Database

design should tackle all these scenarios and will be able to scale efficiently with new data.

For Assignment$\_01$:

kindly clearly mention the following in your final ERD:

$1)$ Different types of attributes $($ Key, descriptive, derived, multi$-$value, and composite etc$)$

$2)$ Weak entities $($if any$)$

$3)($min cardinality, max cardinality$)$

$4)$ Optional$/$mandatory cardinalities

$5)$ Total and partial participation

$6)$ Associative

entities $($if any$)$