Question: you would need to create tables for each entity and define the corresponding attributes and primary keys as specified,Establish relationships between tables. I need screenshot
you would need to create tables for each entity and define the corresponding attributes and primary keys as specified,Establish relationships between tables. I need screenshot of end result. Based on the scenario, following entities are identified:
Employee: Represents the employees within the organization.
Department: Represents different departments within the organization.
Job Position: Represents the job roles available within the organization.
Candidate: Represents individuals applying for jobs.
Job Application: Represents applications submitted by candidates for specific job positions.
Performance Review: Represents the performance evaluation of employees.
Manager: Represents the managers who oversee the departments and conduct performance reviews.
Employee:
Attributes: Employee ID Primary Key First Name, Last Name, Department ID Job Position ID Date of Hire, Manager ID
Primary Key: Employee ID
Department:
Attributes: Department ID Primary Key Department Name, Manager ID
Primary Key: Department ID
Job Position:
Attributes: Job Position ID Primary Key Job Title, Department ID Salary Range
Primary Key: Job Position ID
Candidate:
Attributes: Candidate ID Primary Key First Name, Last Name, Contact Information, Resume
Primary Key: Candidate ID
Job Application:
Attributes: Application ID Primary Key Candidate ID Job Position ID Date Applied, Application Status
Primary Key: Application ID
Performance Review:
Attributes: Review ID Primary Key Employee ID Review Date, Performance Score, Comments
Primary Key: Review ID
Manager:
Attributes: Manager ID Primary Key First Name, Last Name, Department ID
Primary Key: Manager ID
Utilize Microsoft Access to identify the attributes and primary keys that
accurately describe the entities. Create tables in Microsoft Access to represent these entities and indicate
the primary keys.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
