This will help you determine your data model and database design.

One department is supported by one or more employee(s)

One employee applies one or more skill(s)

One customer submits one or more purchase(s)

One product can be delivered for one or more purchase(s)

 

Entity - CUSTOMER, INVOICE, PURCHASE, EMPLOYEE, DEPARTMENT

Attribute - Address, City, Province

 

2- Add an EMPLOYEE entity with the identifying attributes FirstName and LastName

 

3- Add the Position and Salary regular attributes to the EMPLOYEE entity

  Could you please check if it is correct?

 

SKILL FirstName LastName SkillName DEPARTMENT DepartmentID DepartmentName CUSTOMER FirstName LastName Company Address PRODUCT ProductName ListedPrice HH supported by supports supports supported by EMPLOYEE FirstName LastName Position Salary Address PURCHASE FirstName LastName ProductName Purchase Date PurchasePrice