FIELD NAME DATA TYPE LevelNo (peimary key) NUMBER Lowsalary NUMBER Highsalary NUMBER DEPENDENT NAME DATA TYPE EmployeeID NUMBER (Foreign key from EMPLOYEE) DependentID NUMBER DEpendentDOB DATE Relation VARCHAR2 Primary Key (DependentID, EmployeeID) EMPLOYEE FIELD NAME DATA TYPE EmployeeId (Primary Key) NUMBER Lname VARCHAR2 Fname VARCHAR2 PositionID NUMBER (Foreign key from POSITON) QualID NUMBER (Foreign key from QUALIFICATION) DeptID NUMBER (Foreign key from DEPARTMENT) Supervisor NUMBER (Foreign key from EMPLOYEE) Salary NUMBER Commission NUMBER HireDate DATE BirthDate DATE
FIELD NAME DATA TYPE LevelNo (peimary key) NUMBER Lowsalary NUMBER Highsalary NUMBER DEPENDENT NAME DATA TYPE EmployeeID (Foreign key from EMPLOYEE) NUMBER DependentID NUMBER DEpendentDOB DATE Relation VARCHAR2 Primary Key (DependentID, EmployeeID) EMPLOYEE FIELD NAME DATA TYPE EmployeeId (Primary Key) NUMBER Lname VARCHAR2 Fname VARCHAR2 PositionID (Foreign key from POSITON) NUMBER QualID (Foreign key from QUALIFICATION) NUMBER DeptID (Foreign key from DEPARTMENT) NUMBER Supervisor (Foreign key from EMPLOYEE) NUMBER Salary NUMBER Commission NUMBER HireDate DATE BirthDate DATE