Hi everyone,
I'm trying to write an application in java, hibernate and struts...or maybe I might do it using PHP. I haven't decided yet. Btw, the application is to track communications I have with employment agencies and individuals relating to job applications I make.
That's the easy bit :-) The problem is at the moment I'm trying to design the database schema. Most of the database schema will be fairly easy to do but one part of it is proving a little difficult.
This concerns three entities: Communication, Person and Agency.
Communication is any kind of communication to or from a person or agency.
Person represents an individual who may or may not belong to an agency, e.g., it might be an ex-colleague giving me a heads-up about an upcoming job. Also, over time, a person might change which agency they belong to.
Agency represents an employment agency advertising jobs. I might have to email my resume to an agency. This means that at this point in the job application process, there is no contact with an individual, just the agency.
I've tried to keep this fairly short but I think I've listed the important points above. I've attached a first attempt, best guess stab at what I think might be an OK design for this bit of the schema.
Please can you give me any suggestions you have for getting this design right please? I'm a newbie to using ER diagrams so go easy on me :-)
Thanks in hope,
fingers25.
