The process of structuring data in a database is known as normalisation. This includes generating tables and defining relationships between them according to rules aimed to secure data while also allowing the database to be more flexible by removing redundancy and inconsistent dependencies.
Normalization is the process of rescaling data from its original range so that all values fall between 0 and 1. Normalization necessitates knowing or being able to estimate the minimum and maximum observable values with accuracy. You might be able to approximate these values based on the information you have.