Question

Draw an entity relationship diagram. Use Crow's foot notation. following is a manager's job Hiring process from managers view point. From your knowledge to make the entity relationship diagram proper you can modify or add additional entity and attributes if necessary but must use the following entities and attributes. Managers (Employee ID, Name, manager from which department) Departments (functional departments, what departments, department ID, name) Job Vacancy (Job Number, Position Name, Position Type fulltime/part time/casual, Department/Brand Classification State, Location) Hiring Manager (Employee ID, Name, Department) Job Ads (Platform, Status, Expiration Date) Job Applicant (Email address, Name, Phone Number, Address Gender, DOB, Work Authorization) Shortlisted Candidate (Applicant No, (interview details?)) Panel Reference

          Draw an entity relationship diagram. Use
Crow's foot notation. following is a
manager's job Hiring process from
managers view point. From your
knowledge to make the entity relationship
diagram proper you can modify or add
additional entity and attributes if
necessary but must use the following
entities and attributes.
Managers (Employee ID, Name, manager
from which department)
Departments (functional departments,
what departments, department ID, name)
Job Vacancy (Job Number, Position Name,
Position Type fulltime/part time/casual,
Department/Brand Classification State,
Location)
Hiring Manager (Employee ID, Name,
Department)
Job Ads (Platform, Status, Expiration Date)
Job Applicant (Email address, Name,
Phone Number, Address Gender, DOB,
Work Authorization)
Shortlisted Candidate (Applicant No,
(interview details?))
Panel
Reference

Added by Rosa M.

Question

Please give Ace some feedback