hey guyz, i have project, i have to design a website starting from the scratch, so i was developing the ER diagrams for it. The website is going to be like bestjobsusa.com, infact with quite less options in it.Basically i m havin lots of problems in designing it.let me tell u till where i have done
here comes the difficult part (atleast i m findin it difficult). These contain the as usual attributes like the name,personal information etc... creating the relations is making me go wild.
If anybody could help, then thanks a lot.........
OK... Start with a conceptual model. What are you designing ?
A system that links job seekers to employers?
Job seekers and employers are roles that people and organizations play. Think about this. Suppose today I (Joe Bobb) am looking for a job. I get tired and start my own business, which surprisingly does real well, so I have to hire some help.
Now am I 'magically' a different person because I'm an employer?
A single individual person can play MANY roles. However.... you've implied that you are forcing people (and organizations) into one of two roles.
Either you're a job seeker, or a job provider.
No... not right. Don't EVER EVER EVER force somebody into a role because the business will change and then your design breaks. How about this? If you enter a company like IBM as an employer or job provider, then how is someone to contact this monster corporation. OF COURSE.... the organization can't speak or talk by itself, but it has an HR Person who represents the company and that is who you contact. See, I just found another role a person plays
Have an entity called people, one called organization, one called roles and create an associate entity between them.
This will allow ANY combination of people or organizations to be related to each other defined by the roles they play.
As far as the login... related that to a person as a separate entity, you might encrypt that.
well ur rite, well the HR( or any one responsible ) of the comapny will represent the orgainzation,well let me it more clear, i was thinking of it to be something like this shown below. The user logs in as anyone of the employer or the jobseeker and respectively searches for each other. i assume havin an organization and then the roles for it would be somewat different.