Having more than 14 years of experience in IT industry, currently playing architect role in database (RDBMS, DBMS, Warehouse).
To support on your project, we need to follow below process:
> Identify all project entities
> Identify all entity attributes
> Mapping entity relationships (one to one, one to many, many to one or many to many)
Once above process will be completed then we can discuss about Normalization (Till which normal form you want to apply)
Let me know if you want to discuss further.