I am looking for an expert in data modelling. We have a database design which stores multiple entities in a many-to-many relationship setting. There is a table with multiple users and there is a table with multiple campaigns. A user can vote on multiple campaigns. A campaign can exist of multiple votes by different user. Each user can only vote once every campaign (just for your information).
A simplified view of the database is attached in an Excel file. Because of Excel's limit to support many-to-many relationships, junction tables need to be created. I would like advice on how to design the junction tables and make the attached data-model work with one-to-many and many-to-one.
11 freelancers are bidding on average €138 for this job
Hi, I am an expert in Database design and I have knowledge and experience in Entity Relationship modeling and designing. I can do this task for you. Thank you.