Query-1: FEMALE_EMPS O SEX="F(EMPLOYEE) EMPNAMESE N ENAME, LNAME, SSN (FEMALE_EMPS) EMP_DEPENDENTS - EMPNAMES x DEPENDENT ACTUAL_DEPS O SSN=ESSN(EMP_DEPENDENTS) RESULT + FNAME, LNAME, DEPENDENT_NAME...


Differentiate the type of query given below and interpret the meaning step-wise if it’s a
sequential query or each part if non –sequential;


Query-1: FEMALE_EMPS O SEX=

Extracted text: Query-1: FEMALE_EMPS O SEX="F(EMPLOYEE) EMPNAMESE N ENAME, LNAME, SSN (FEMALE_EMPS) EMP_DEPENDENTS - EMPNAMES x DEPENDENT ACTUAL_DEPS O SSN=ESSN(EMP_DEPENDENTS) RESULT + FNAME, LNAME, DEPENDENT_NAME (ACTUAL_DEPS) {uv | ($ q) ($ r) ($ s) ($ t) ($ w) ($ x) ($ y) ($ z) (EMPLOYEE(qrstuvwxyz) and q='John' and r='B' and s='Smith')} Query-2: Query-3: {e.LNAME, e.FNAME | EMPLOYEE(e) and ( (" x)(not(PROJECT(x)) or not(x.DNUM=5) OR ( ($ w)(WORKS_ON(w) and w.ESSN=e.SSN and x.PNUMBER=w.PNO))))}

Jun 11, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here