6 algebra storage.ppt NJ company database Figur One possible database state for

Question

6 algebra storage.ppt NJ company database Figur One possible database state for the COMPANY relational database schema EMPLOYEE Frame Mnit Bdase Address Sea salay super Dino Frankie T Wong 339445555 1955.12 0e le38 Voss Houston TXM 40000 Bes555555 5 M 25000 982054321 4 DEPARTMENT DEPT LOCATION Research 333445555 1988 o522 Houston WORKS ON 453453453 2 200 333445555 3 100 3344 5555 D10 100 333445555 F 1900-0408 Daughter 1989-1025 Son 1963 S LEN] example Figure 6 Figure 65 The CARTESIAN PRODUCT (CROSS PRODUC) operation. FEMALE EMPs Frame Mait Lname Sen Bdate Address See Salary Super

Explanation / Answer

EmpDep <-- Employee *SSN=ESSN Dependent
SupDep <-- EmpDep *SSN=SSSN Employee
Result <-- LName(SupDep)

First statement joins employee with dependent and only employees with dependents will be fetched
Next statement joins this result with employee on SSSN column so only supervisors will be fetched
Next is result which displays latsname

Related Questions

Navigate

• Browse (All)
• Browse 6
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.