Normalisation of a Cryptocurrency Exchange Database

A cryptocurrency exchange needs a database to manage user accounts, cryptocurrencies,

and trading activities. Each user has a unique user ID$,$ username, email, and account

balance. Each cryptocurrency is described by a unique crypto ID$,$ name, symbol, and current

value. Users can perform multiple trades, and each trade is identified by a unique trade ID$,$

trade date, type $($buy$/$sell$),$ quantity, price, and the involved user and cryptocurrency IDs.

Tasks:

$($a$)$ Identify and place all attributes into a flat schema for the cryptocurrency exchange.

$[5$ marks$]$

$($b$)$ Identify potential anomalies $($insertion$,$ deletion, and update$)$ in the current database

design.

$[5$ marks$]$

$($c$)$ Determine the functional dependencies that exist in the database schema.

$[5$ marks$]$

$($d$)$ Describe and illustrate the process of normalizing the database to $3NF$ relations,

identifying primary, alternate, and foreign keys in your $3NF$ relations.

$[10$ marks$]$

$[$Total marks: $25]$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