How can I make plans for a ProResume database and turn them into an ER diagram? Also, what ER diagram tools might you know of that are possibly free and nice to use with MySQL?
I am learning ER diagrams learning one, many, one and only, zero or one, one or many, and zero or many for the cardinality rules to create databases with.
Question:
How can I make plans for a ProResume
This is the plan I have thus far;
ENTITIES
Employers: These will be the companies or organizations that are hiring.
Attributes: Employer ID, Company Name, Location, Contact Information
Customers: These will be the Job Applicants or Candidates.
Attributes: Customer ID, Name, Contact Information, Education, Experience
References: These will be the references from customers.
Attributes: Reference ID, Name, Contact Information, Relationship to Customer
Skills: Will be software and hardware skill of the customer.
Attributes: Skill ID, Skill Name, Proficiency Level
Employment Positions: These will be the employment position held by customers.
Attributes: Position ID, Position Title, Company Name, Duration, Responsibilities
Interviews: Will be the interviews conducted with customers.
Attributes: Interview ID, Interview Date, Interviewer, Feedback
Hiring Status: This will be whether the customer was hired or not.
Attributes: Hiring Status ID, Customer ID, Employer ID, Hire Date
Also, it would be helpful for myself to be able to identify the candidate and primary keys for the entities.
Thank you!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
