MySQL Table Normalisation for App

$10-30 AUD

Completed

Posted

over 7 years ago

$10-30 AUD

Paid on delivery

I have a MySQL Database with myphpadmin access. 1 table called 'publications' has a column which has multiple authors separated by commas in each cell and hence will be a Many to Many relationship. I need someone to go through and generate an authors and an authorspublications table based on this. You will also need to include the order of the names within the authorspublications table (in a ranking column). There are many authors which are duplicates because some have extra spaces and ect. It would be great if you could also merge these duplicates under the same new author ID. Feel free to ask any questions. YOU WILL ONLY GET PHPMYADMIN ACCESS

Project ID: 11539355

About the project

6 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@hishamhaniffa

HI, I have extensive training and knowledge on desktop application, web development and graphics designing. I have over 5 years of experience in IT industry and completed various number of projects successfully and within the given time frame. These are some of the technologies and frameworks that I have used in my past projects and comfortable in using them for your project. HTML/ CSS PHP/ MySQL/ PostgreSQL/ SQLite Java/J2SE/J2EE Javascript/ NodeJS/ AngularJS/ ReactJS/ EmberJS/ VueJS C/ C++/ Qt Apps Python scripts Visual Basic/ .NET/ ASP.NET/ MS SQL WordPress (Theme and Plugin Dev)/ Laravel/ CodeIgniter/ SlimFramework/ Custom MVC Frameworks Photoshop/ Illustrator/ Affinity Designer Webservices - XML/JSON ( Java/ PHP) Chrome Extension Development Multiple JS frontend libraries like jQuery/ ChartJS/ etc. Thank you Hisham Haniffa

$15 AUD in 1 day

4.8

(18 reviews)

4.0

6 freelancers are bidding on average $22 AUD for this job

@it2051229

Hi there, I would like to do this project if given the opportunity. Let me know if you are interested so I can have further details. Thanks.

$30 AUD in 1 day

5.0

(354 reviews)

6.6

@amutinda

I have carefully read your job description, and because I am a graduate with good command of English and having worked with a consulting firm where such work happens to be part of the duties as a web dev and CTO. With Good web and mobile programming skills and Having worked on several such Projects, I am confident I can complete your job very well . Please contact me for more discussion also it would be good to mention How much data we are talking about

$25 AUD in 1 day