A software contract and consultancy firm maintains details of all the various projects in which its employees are currently involved. Based on the provided ERD, business rules and data dictionary, please create the Oracle database tables using SQL Data Definition Language (DDL).

 

Transcribed Image Text:

DEPARTMENT ATTRIBUTE NAME DepartmentCode DepartmentName CONTENTS Department code Department name Data Dictionary Software Contract and Consultancy Firm Database DATA TYPE AND SIZE FORMAT Number (2) Varchar2 (30) XXXX XXX RANGE REQUIRED? DEFAULT UNIQUE? VALUE PK OR FK FK REFERENCED TABLE Yes PK Yes Yes EMPLOYEE ATTRIBUTE NAME CONTENTS DATA TYPE AND SIZE FORMAT RANGE REQUIRED? DEFAULT UNIQUE? VALUE PK OR FK FK REFERENCED TABLE EmployeeNo EmployeeName EmployeeBirthDate DepartmentCode Employee number Employee full name Employee date of birth Department code Number (5) Yes PK Varchar (30) XXX Yes Date Yes Number (2) Yes FK DEPARTMENT PROJECT ATTRIBUTE NAME CONTENTS DATA TYPE FORMAT RANGE REQUIRED? AND SIZE DEFAULT VALUE UNIQUE? PK OR FK FK REFERENCED TABLE Number (6) Varchar (200) Number (5) Yes PK Yes Yes FK EMPLOYEE ProjectCode Project code ProjectDescription SupervisorNo Project description Supervisor number TASK ATTRIBUTE NAME CONTENTS DATA TYPE AND SIZE FORMAT RANGE REQUIRED? DEFAULT VALUE UNIQUE? PK OR FK FK REFERENCED TABLE TaskNo Task number Number (7) Yes PK ProjectCode Project code Number (6) Yes FK PROJECT EmployeeNo Employee number Number (5) Yes FK EMPLOYEE DEPARTMENT ATTRIBUTE NAME DepartmentCode DepartmentName CONTENTS Department code Department name Data Dictionary Software Contract and Consultancy Firm Database DATA TYPE AND SIZE FORMAT Number (2) Varchar2 (30) XXXX XXX RANGE REQUIRED? DEFAULT UNIQUE? VALUE PK OR FK FK REFERENCED TABLE Yes PK Yes Yes EMPLOYEE ATTRIBUTE NAME CONTENTS DATA TYPE AND SIZE FORMAT RANGE REQUIRED? DEFAULT UNIQUE? VALUE PK OR FK FK REFERENCED TABLE EmployeeNo EmployeeName EmployeeBirthDate DepartmentCode Employee number Employee full name Employee date of birth Department code Number (5) Yes PK Varchar (30) XXX Yes Date Yes Number (2) Yes FK DEPARTMENT PROJECT ATTRIBUTE NAME CONTENTS DATA TYPE FORMAT RANGE REQUIRED? AND SIZE DEFAULT VALUE UNIQUE? PK OR FK FK REFERENCED TABLE Number (6) Varchar (200) Number (5) Yes PK Yes Yes FK EMPLOYEE ProjectCode Project code ProjectDescription SupervisorNo Project description Supervisor number TASK ATTRIBUTE NAME CONTENTS DATA TYPE AND SIZE FORMAT RANGE REQUIRED? DEFAULT VALUE UNIQUE? PK OR FK FK REFERENCED TABLE TaskNo Task number Number (7) Yes PK ProjectCode Project code Number (6) Yes FK PROJECT EmployeeNo Employee number Number (5) Yes FK EMPLOYEE