Write and implement a Python script to create a schema and populate a MySQL database.

Implement the database described by the logical model created in Task 2 using a Python script and a running instance of MySQL.

This script should also crunch the CSV file and populate the database - i.e. automate Task 4 above.

	id|quote|source|dob|dod|wplink|wpimg|category
	1|I shall tell you a great secret, my friend. Do not wait for the last judgment. It takes place every day.|Albert Camus|1913|1960|https://en.wikipedia.org/wiki/Albert Camus|https://upload.wikimedia.org/wikipedia/commons/0/08/Albert_Camus%2C_gagnant_de_prix_Nobel%2C_portrait_en_buste%2C_pos%C3%A9_au_bureau%2C_faisant_face_%C3%A0_gauche%2C_cigarette_de_tabagisme.jpg|politics, philosophy
	2|Dear Mrs. Chown, Ignore your son's attempts to teach you physics. Physics isn't the most important thing. Love is. Best wishes, Richard Feynman.|Richard Feynman|1918|1988|https://en.wikipedia.org/wiki/Richard_Feynman|https://upload.wikimedia.org/wikipedia/en/4/42/Richard_Feynman_Nobel.jpg|science, love
	3|I think I can safely say that nobody understands quantum mechanics.|Richard Feynman|1918|1988|https://en.wikipedia.org/wiki/Richard_Feynman|https://upload.wikimedia.org/wikipedia/en/4/42/Richard_Feynman_Nobel.jpg|science,humour
	4|Science may set limits to knowledge, but should not set limits to imagination.|Bertrand Russell|1872|1970|https://en.wikipedia.org/wiki/Bertrand_Russell|https://upload.wikimedia.org/wikipedia/commons/5/5f/Bertrand_Russell_1957.jpg|philosophy, science
	5|Nothing in education is so astonishing as the amount of ignorance it accumulates in the form of inert facts.|Henry Brooks Adams|1838|1918|https://en.wikipedia.org/wiki/Henry_Brooks_Adams|https://upload.wikimedia.org/wikipedia/commons/b/bf/William_Notman_-_Henry_Brooks_Adams%2C_1885_%28transparent%29.png|education
	6|Any astronomer can predict with absolute accuracy just where every star in the universe will be at 11:30 tonight. He can make no such prediction about his teenage daughter.|Ronald Reagan|1911|2004|https://en.wikipedia.org/wiki/Ronald_Reagan|https://upload.wikimedia.org/wikipedia/commons/1/16/Official_Portrait_of_President_Reagan_1981.jpg|humour

view rawquotes6.txt hosted with by GitHub