EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT_LOCATIONS Dnumber
Posted: Mon Jun 06, 2022 4:49 pm
- Employee Fname Minit Lname Ssn Bdate Address Sex Department Dname Dnumber Mgr Ssn Mgr Start Date Dept Locations Dnumber 1 (46.1 KiB) Viewed 22 times
OP7: DEPARTMENT JOIN Mgr_ssn=Ssn EMPLOYEE
EMPLOYEE Fname Minit Lname Ssn Bdate Address Sex DEPARTMENT Dname Dnumber Mgr_ssn Mgr_start_date DEPT_LOCATIONS Dnumber Dlocation PROJECT Pname Pnumber Plocation Dnum WORKS ON Essn Pno Hours DEPENDENT Essn Dependent_name Sex Bdate Relationship Salary Super_ssn Dno Figure 5.5 Schema diagram for the COMPANY relational database schema.