Need some DB experts: setting up a MySQL Database for a Curriculum Vitae system...
I work for a department in a University that is looking to update the method which we currently "post" our CVs (Curriculum Vitae; similar to a resume) online. Currently, our professors update their CVs manually, send them to their secretaries, who in turn send them to me. I upload them and add them to our webpage manually.
However, since I've taken over as webmaster, I've been making the push for more dynamic, database-driven sites. We're going to be switching to a PostNuke site soon, so people can add news, etc., on their own, without me having to intervene all over the place. This push for interactive sites has gone to the CV system. So, with that in mind, I'm looking to either program, or help implement, a new CV system that allows professors to directly publish their CVs via our site.
Before I begin on programming this, though, I'm looking for the best way to do it, specifically in developing the database. I'm fairly new to MySQL databases, which is what we are using, so any help here would be appreciated.
Here is what the system will do:
Data is stored in a very granular, detailed style, then is dynamically formatted and delivered via the user's preferred method (PDF, LaTex, HTML, etc). Here is an example of the data:
-Lecturer, Department of Biostatistics, UCLA, Los Angeles, California, 1975
-Research Assistant Professor, Department of Medicine, University of Washington, Seattle, Washington, 1980-84
As you can see, the "Position" category - which is one of several categories within the CV itself - is broken down like this:
[Dates Position Held]
As you can see, this is going to be a fairly intricate and complex system. At the moment, I can't figure out the best way to develop it. I hope what I've written isn't too confusing; here is another example to help you understand.
- -subcategories also shown above
-Honors and Awards
That's the gist of it, but the fields continue after that. The online CVs we will be providing will also have published articles, which would be separated into several subcategories (author(s), title, date, journal name), books, teaching experience, and a number of other categories, each which will have subcategories.
I'm somewhat familiar w/MySQL, as I stated, but this is above my head. Can anyone lend a hand or point me in the right direction? I have some PHP/MySQL books at my side and all summer to program this system, but I can't quite get a grasp on it yet.
a billion (and one) thanks,