I am developing an attendance system for an institue.
I have a two tables called Employee and Technology.
Employee has the following structure
Ecode Ename Departmentcode Tcode (Allow null) ----> DepartmentCode Dname
1 Das A01 --- > A01 Admin
2 Peter T03 Dtt T03 Technical
3 anand H02 H02 HR
4 Henry T03 Jav
5 Jessica T03 Oc
6 Ram T03 Ux
Tcode Technology name
But there are many faculties who can take more than one technology. how do i maintain that..
one idea from my side is designing the employee table with tcode1 tcode2 tcode3 and mapping it to technology.
Is this correct? please advice