bd ficha 1 parte 2 relax

group: ficha3parte2


Employee = {
	empNo:number, fName:string, lName:string, address:string, DOB:date, sex:string, position:string, deptNo:number
	1, 'Joao', 'Paulo', 'rua da figueira', 1955-01-20, feminino, CEO, 1
	2, 'Ana', 'Isabel', 'rua do arco', 1982-04-10, feminino, Senior, 2
	3, 'Pedro', 'Miguel', 'praça da alegria', 1978-10-06, masculino, Temp, 3
	4, 'Joana', 'Faria', 'praceta do anjo', 1980-05-25, feminino, Senior, 4
	5, 'James', 'Adam', 'home office', 1981-08-25, masculino, Manager, 1
}

Department = {
	deptNo:number, deptName:string, mgrEmpNo:number
	1, IT, 5
	2, RH, 1
	3, CC, 5
	4, SP, 1
}

Project = {
    projNo:number, projName:string, deptNo:number
    1, Projeto1, 4
    2, SCCS, 1
    3, Projeto2, 3
    4, Projeto4, 2
}

WorksOn = {
    empNo:number, projNo:number, dateWorked:date, hoursWorked:number
    1, 4, 2016-04-02,106
    2, 1, 2018-05-16,200
    3, 2, 2019-08-20,50
    4, 3, 2020-04-20,75
}