group: project

Employee = {
empNo:string, fName:string, iName:string, address:string, DOB:string, sex:string, position:string, deptNo:string

'S005','Blake','Richardson','London','25 Dec 1983','M','Director','N01'
'S007','Taylor','Swift','Aberdeen','12 Oct 1981','F','Manager','N02'
'S003','Lisa','Blackpink','Glasgow','3 Jan 1985','F','Secretary','N03'
'S004','Maudy','Ayunda','Kudus','5 Jun 1992','F','Developer','N04'
'S002','Iqbaal','Ramadhan','London','22 Oct 1991','M','Assistant Manager','N05'
}


Department = {
deptNo:string, deptName:string, mgrEmpNo:string

'N03','Financial','LG01'
'N04','SCCS','LD02'
'N01','HR','LS03'
'N02','IT','LK05'
'N05','Marketing','LX04'
}


Project = {
projNo:string, projName:string, deptNo:string

'FR03','Joker','N03'
'FG04','KungFu Panda','N04'
'FL01','Nussa','N05'
'FO02','Antribos','N01'
'FP05','eFishery','N02'
}


WorksOn = {
empNo:string, projNo:string, dateWorked:string, hoursWorked:string

'S003','FO02','3 May','7 hours'
'S004','FG04','6 Jul','5 hours'
'S007','FL01','19 Mar','6 hours'
'S002','FP05','30 Mar','8 hours'
'S005','FR03','01 Jun','6 hours'
}