Enterprise Database for an Online Multiplayer Game

A popular online multiplayer game needs a database to manage its players, quests, and

achievements. The database must track players, quests, and achievements. Each player

has a unique player ID$,$ username, email, and level. Each quest is described by a unique

quest ID$,$ quest name, difficulty level, and reward points. Achievements are milestones

players can reach, each identified by a unique achievement ID$,$ name, and description.

Players can undertake multiple quests and earn multiple achievements.

Tasks:

$($a$)$ Design a schema for the online multiplayer game, identifying primary keys, foreign keys,

and other relevant attributes. Comment on the normalisation of your designed schema,

indicating what normal form it is in and why.

$[5$ marks$]$

$($b$)$ Create an ERD to represent the data used by the online multiplayer game's management

system. State any assumptions you make in your design.

$[7$ marks$]$

$($c$)$ Explain in detail how you arrived at the cardinalities in your ERD.

$[$Total marks: $20]$