Search the Community

Hey guys, I'm entering the amateurish level of programming right now, but have a challenging project ahead of me. Here is a brief scope of the problem: We are collecting a lot of data. It ends up being essentially 53 columns in the CSV. The first thing I noticed was that there were certain portions of the data that were very likely to repeat. This led to the following Schema (MySQL) to decrease redundancies: TABLE Markets (Relies on nothing) (Holds data about markets) TABLE Contacts (Relies on markets) (Contacts are associated with a market) TABLE Events (The events belong to both a market and a contact) TABLE Event Products (This only relies on an Event) Essentially my task is to automate the process since we'll be processing thousands of rows. So the script would probably need to behave like so: Import in markets Then import associated contacts (as well as the unique market id assigned by MySQL) Then import associated events (placing the unique market and contact id assigned by MySQL as well) Then import associated event products (placing the unique event id assigned by MySQL as well) As you can see this is probably really challenging. I've looked around a bit for some decent tutorials or reading. Sorry for the long winded post, here are my three questions: I cannot accurately estimate how long a project like this should take me, in your experience how long does a project like this take? Am I going about this the right way? (Even using PHPMyAdmin to import took a long time due to having to get the appropriate ids) Do you know of any good resources, or books for this? Thanks a million!