I will professionally do your database normalization
About this Gig
Do you have a messy Excel or CSV dataset that needs to be cleaned, structured, and normalized? I will transform your flat or poorly structured dataset into a well-organized relational database structure using proper database normalization principles.
Depending on your selected package, I can normalize your flat dataset up 20 relational tables, identify entities and relationships, define primary and foreign keys, create an Entity Relationship Diagram (ERD), and provide an SQL database schema.
What I can help you with:
- Excel and CSV dataset structuring
- Database normalization (1NF, 2NF & 3NF)
- Entity and attribute identification
- Primary and foreign key identification
- Relational database design
- ERD / database schema diagram
- SQL table creation scripts
- Clean and organized normalized tables
- Basic database documentation
You can send me Excel files, CSV files, database flat tables or existing database that need normalization. Message me before ordering if your dataset is large or requires a custom database design.
Database type:
Relational database
Platform:
SQL Server
Expertise:
Big data
•
ERD
•
Normalization
•
SQL
My Portfolio
FAQ
What did you need from me to get started?
I need your Excel, CSV, or existing database file and any specific requirements you have. If possible, also tell me what the data represents and what you want the final database to achieve. This helps me structure and normalize your data correctly.
Can you normalize an Excel or CSV dataset?
Yes. I can transform a flat or poorly structured Excel/CSV dataset into a properly structured relational database and normalize it according to your selected package (1NF, 2NF, or 3NF).
What is included in database normalization?
Depending on the package, I can identify entities and attributes, remove repeating groups and unnecessary dependencies, define primary and foreign keys, separate data into related tables, and structure the database according to 1NF, 2NF, or 3NF.
Will you create an ERD for my dataset?
Yes. An Entity Relationship Diagram (ERD) is included in the Standard and Premium packages. It will show the tables, keys, and relationships within your normalized database structure.
Do I need to have an existing database?
No. You can simply provide your Excel or CSV dataset. I can analyse the flat data, identify the entities and relationships, and develop the normalized relational structure from it.
