Creation of Junction Tables in a data model

Closed

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.

Skills: Big Data, Database Administration, MySQL, Software Architecture

See more: i need expert advice in excel, how to expert in excel, how to be an expert on excel, how to be an expert in excel, how can i expert in excel, excel model expert, excel expert advice, creation architecture, be an expert in excel, model view view model, how to design a database, database creation software, how to be expert in excel, table creation, EXCEL MODEL, model architecture, software vote, creation excel, excel data creation, design model excel, model design database, excel table mysql, excel database expert, model excel, model work

Project ID: #5225273

11 freelancers are bidding on average €138 for this job

gopalvora

Hi ready to start i had more than 5 year experience in the php , mysql , jquery etc.. so let me know your view Thanks

€195 EUR in 5 days
(129 Reviews)
6.7
eperfections

<<TOP RANKED PROGRAMMER AND DATABASE EXPERT>> Done 600+ projects. I am highly interested in getting this project done for you. Thanks

€144 EUR in 3 days
(106 Reviews)
6.5
codersam

Dear Sir, I have read your exell file and completely understood what you need. I can design your database based on your relation. I am Mysql Dabase Administrator. So I can design a normalized database sch More

€155 EUR in 3 days
(43 Reviews)
6.5
elboukharimu

Hi, I'm very interested helping you designing your database, I have more then 7 years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is More

€150 EUR in 5 days
(22 Reviews)
4.7
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 200 projects. Please look at the feedback left by my employer to know more about my work. Waiting for your positive More

€111 EUR in 3 days
(36 Reviews)
4.6
schungur

DATABASE EXPERT... CHECK MY BADGES... This is easy project and it can be delivered very fast. Unfortunately I'm available on for the weekend, so if you react soon, you can count to get your database until Sunday eveni More

€133 EUR in 2 days
(15 Reviews)
4.2
mdakteruzzaman

Hi, I have been working as Database Analyst more than 9 years. Earlier I completed B.Sc. Engg and M.Sc. Engg both in computer engineering. Thanks

€155 EUR in 4 days
(11 Reviews)
4.1
romanuwa

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.

€100 EUR in 5 days
(12 Reviews)
3.7
swarm22

I have +4 year experiences in data modeling . To provide well documented , quality and result oriented work Thanks & Regards Hardik G. Dumaswala

€155 EUR in 7 days
(2 Reviews)
2.4
wvandenputte

Hallo Gezien het vlagje naast uw profiel vermoed ik dat u ook Nederlands spreekt wat ik dus ook zal doen om de communicatie iets vlotter te laten verlopen. Vanuit uw beschrijving veronderstel ik dat u voornamelijk e More

€55 EUR in 2 days
(0 Reviews)
0.0
iuqoZJsGicyE

Hi we are a team of freelance software developers, if you contact me at our website we can discuss the details of the project. w w w.so l v e r .i o

€155 EUR in 3 days
(0 Reviews)
0.0
mxlogic

Dear Sir Hi, Greetings of the day and thanks for sharing these details and allowing me to bid on this assignment. yes we have similar experience and can deliver u as u have mentioned in your requirements. we More

€185 EUR in 9 days
(0 Reviews)
0.0
testotorko

I am an experienced PHP Programmer, and have worked with it for many years. I also specialise in Graphic Designing. I am also experienced in Graphic Design and HTML. I am looking to be hired and work on projects More

€170 EUR in 7 days
(1 Review)
2.6