Convert the following ERDs to a Database schema. Follow all the steps in order as learned in this class. Identify PKs 
and FKs for each relation. Explain your work.

 

Transcribed Image Text:

Press esc to exit full screen Page < 2 of 3 RegionName CharName MaxHitPoints Climate AcctName Level MaxMana Precipitation Password LastPlayed ExpPoints CurrHitPoints Foliage LastSigned On Created On CurrMana PlayersIn 1 N N Account Has Character Contains 0000000 SbscrbrName SbscrbrAddress SbscrbrEmail SbscrbrPhone AcctCreated On CreepName HitPoints Mana Attack Region 1 Carrying WhenCreated ItemName N M IDNum RanInfo Item Instantiation N IsType Item N Modifier N Item Type Carrying 1 ItemDamage 1 1 N Creep IsType Creep Instantiation N Contains IDNum ZOOM + Press esc to exit full screen Page < 2 of 3 RegionName CharName MaxHitPoints Climate AcctName Level MaxMana Precipitation Password LastPlayed ExpPoints CurrHitPoints Foliage LastSigned On Created On CurrMana PlayersIn 1 N N Account Has Character Contains 0000000 SbscrbrName SbscrbrAddress SbscrbrEmail SbscrbrPhone AcctCreated On CreepName HitPoints Mana Attack Region 1 Carrying WhenCreated ItemName N M IDNum RanInfo Item Instantiation N IsType Item N Modifier N Item Type Carrying 1 ItemDamage 1 1 N Creep IsType Creep Instantiation N Contains IDNum ZOOM +