Drawing ERD Entities Relationship Diagram Samples for Students

Question: Discuss about the Entities Relationship Diagram. Answer: ERD modelling Assumptions Any candidate on reading web advert can apply for a job and the system will automatically generate a response mail. On successful completion of application form by the candidates will create a direct status to complete and the hiring manager will be notified. Every agent will make a website advert on receiving the job application email from the HS. Job applications done from the agents websites can be sent through email as well and HS processes them without any complication Every candidate application can will receive one or more notification mail of form received or form completion status. Every agent will receive one mail for job description at every time of new job is sent to HS by the hiring manager. Hiring managers can send many jobs description to the HS since each manager has his own jobs to recruit in the workers. Recommendations The system should have an authentication and strict validation security mechanism that will help in correct flow of data processes. There should exist an automated application form checker which notes the completion status and forwards the qualified staff to the hiring manager. Since the system is automated, there should exist a mechanism of checking of application forms against job requirement experience and inform the candidate on qualifications. I.e. whether he has been approved or ignored. The system should allow choosing of jobs from the application form and on candidate fill of the form, the same data should be updated on the managers side through notification since every job advert is linked to its hiring manager. This is possible since the database data is interlinked through use of foreign keys.