Database Mappatura
- View Compenteces
CREATE VIEW competences_view AS
SELECT
c.competenceName,
i.instituteName,
g.groupName,
ca.CompAreaName
FROM competences c
JOIN institutes i ON c.instituteID = i.instituteID
JOIN `groups` g ON c.groupID = g.groupID
JOIN CompArea ca ON c.classification = ca.CompAreaID;