I need to build a small database for human resource department. In Employee tabl

Question

I need to build a small database for human resource department. In Employee table Emp_id is primary key. In Job table Job_id is primary key, Referring Emp_id from the Employee table i.e, Foreign key. In Position table Referring Emp_id,Job_id from Employee table and job table i.e, both are Foreign keys. In Skill table Skill_id is the primary key and Referring Emp_id,Job_id from Employee table and job table i.e, both are Foreign keys. Entity -Relation Diagram: In Employee table Emp_id is primary key. In Job table Job_id is primary key, Referring Emp_id from the Employee table i.e, Foreign key. In Position table Referring Emp_id,Job_id from Employee table and job table i.e, both are Foreign keys. In Skill table Skill_id is the primary key and Referring Emp_id,Job_id from Employee table and job table i.e, both are Foreign keys. Entity -Relation Diagram:

Can you show me how an Entity-Relationship Diagram that shows the table names, column names, and keys would look like in SQL management studio based on the information i provided above? (keep in mind I am making a normalized database)

Small database First Name L Name Mail EMPLOYEE Hire Date has omission hains mor -sal -TOB n Sa EMP-1P TOB Title rtment. TOB -IDY JOB TITLE GRADE M POSITION SKILL SKILL -ID Skliu-DESC RIPTION

Explanation / Answer

1. Employee table:

2. Position Table:

3. Job Table

4. Skill Table

Emp_Id (Key) First_Name L_Name E_Mail Ph_No Hire_Date Comission

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.