Question: Write PHP Web interfaces for the queries Select emp.Fname, emp.Lname From employee em, works_on w, project p Where emp.Dno = 5 and emp.ssn = w.Essn
Write PHP Web interfaces for the queries
Select emp.Fname, emp.Lname
From employee em, works_on w, project p
Where emp.Dno = 5 and emp.ssn = w.Essn and w.Pno = p.pnumber and p.pname = ProductX and w.hours > 10
Select emp.Fname, emp.Lname
From employee emp, dependent d
Where emp.ssn = d.essn and emp.Fname = d.Dependent_name
Select emp.Fname, emp.Lname
From employee emp, employee emp1
Where emp1.Fname=Franklin and emp1.Lname = Wong and emp.superssn=emp1.ssn
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
