A multinational engineering company relational schema is as follows:
_ Employee (NIN, fName, lName, address, DOB, sex, salary, taxCode, deptNo)
_ Department (deptNo, deptName, managerNIN, businessAreaNo, regionNo)
_ Project (projNo, projName, contractPrice, projectManagerNIN, deptNo)
_ WorksOn (NIN, projNo, hoursWorked)
_ Business (businessAreaNo, businessAreaName)
_ Region (regionNo, regionName)
where Employee contains employee details and the national insurance number NIN is the key.
Department contains department details and deptNo is the key. managerNIN identifies the employee who is the manager of the department. There is only one manager for each department.
Project contains details of the projects in the company and the key is projNo. The project
manager is identified by the projectManagerNIN, and the department responsible
for the project by deptNo.
WorksOn contains details of the hours worked by employees on each project and (NIN, projNo) forms the key.
Business contains names of the business areas and the key is businessAreaNo. and Region contains names of the regions and the key is regionNo.
Redesign this schema to take advantage of the new features of SQL3. Add user defined functions that you consider appropriate.
Note : Draw the UML of the schema