MySQL Table Normalisation for App

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.


Umiejętności: Projekty graficzne, HTML, PHP, Projektowanie stron www

Zobacz więcej: hi there id like to be considered for your writing position and im glad to answer any questions you may have thank you for your , update table mysql net merge, drupal easy website build, alibaba website build, handicapping website build service design, joomla commerce website build, full website build, jsp login form user table mysql, matrix table mysql, copy exitsing website build site, simple web app update table database, parse html table mysql, php drop list values table mysql, loop throu table mysql php, drag drop website build bracelet, desc table mysql, iphone app development php mysql, teacher rating website build, bid website build, common questions freelance website build

O pracodawcy:
( 37 ocen ) Albany, Australia

Numer ID Projektu: #11539355

Przyznany użytkownikowi:


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 w Więcej

$15 AUD w 1 dzień
(18 ocen)

6 freelancerów złożyło ofertę na kwotę $22 do tego projektu


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 w ciągu 1 dnia
(354 Oceny)

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. W Więcej

$25 AUD w ciągu 1 dnia
(23 Oceny)

I have more than 5 years of professional and practical experience in MySQL and database development. I have more than 1800 answers in Stackoverflow(Q&A Site) [login to view URL] Więcej

$30 AUD w ciągu 1 dnia
(13 Oceny)

Warm Welcome Client Good Day!!!! Thank you for this opportunity,I feel happy to bid on this project. Hi,I am professional developer .I help you in fixing your mysql table normalisation Please view my mysql sit Więcej

$18 AUD w ciągu 1 dnia
(3 Oceny)

Hello, I understand that you are looking for creating an authors and an author’s publications table on MySQL database. I understand your requirement and I can offer valuable service to fulfill your needs about your Więcej

$15 AUD w ciągu 1 dnia
(0 Oceny)