You are a database administrator for a famous Massively Multiplayer Online Role-Playing Game (MMORPG). The game has
Question:
You are a database administrator for a famous Massively Multiplayer Online Role-Playing Game (MMORPG). The game has millions of users worldwide and thousands of characters that are constantly evolving. As part of the development team, you are responsible for managing and maintaining the database used by the game. The following are the specifications requested by the product owner :
a. What are the entities associated with the MMORPG game? Describe each entity and its attributes.
b. How do you manage the database to store leaderboard data that stores information about players with the highest levels of achievements in the game?
c. How do you manage the database to store purchase transactions for virtual items like skin, armor, equipment, etc?
d. Create an example of data in UNF form of the MMORPG game data, then show the process from UNF to 1NF, 1NF to 2NF, 2NF to 3NF, along with terms and conditions along with sample data.