I have an assignment of my course of Database Management. I have to look for dat
I have an assignment of my course of Database Management. I have to look for data (excel sheets), clean the data, and built an relational schema (snowflake) and design a Entity Relational Model, detailing the entities and the attributes (main key, foreign keys, etc).
My topic is Dementia Medical treatment in England. I have excel sheets with data, but my main problem is how to organize the data in such a way to build the relational schema and the E-R model.
The person should be familiar with database management fundamentals and use of trifacta (to prepare, clean the data).
I have the following information:
Document 1 – VALIDATION PROJECT Attached the scope of work (I mentioned the general scope, the data sources and my objectives)
Document 2 – A flow chart diagram of the activity (Health care management) and some KPIs that would be required.
I have problems attaching the documents, I could send by e-mail or any other way.
Any questions, let me know. I understand that further questions will be necessary.