$1.$ From the scenario description and the data analysis results, identify the vital functional dependencies that should exist among the attributes.

$2.$ Use the functional dependencies listed in Question $1$ to validate the relation schemes and further normalise the relation schemes to $3$NF$.$

$3.$ Collect all attributes into an artificial universal table. Use the functional dependencies in Question $2$ to conduct normalisation from $1$NF to $3$NF