Create a View (V_EMP_DEPT_PROJ) statement that joins the EMPLOYEE and EMPPROJACT (join on EMPNO) and PROJECT table (join on PROJNO). Limit the view to contain :

o ID

o Name (FirstName and Lastname)

o WorkDept

o Salary

o ACTNO

o PROJNO

o PROJNAME

o Where Salary < 100000

 

contacttype id INT(11) label VARCHAR(255) Indexes contact pid INT(11) ctid INT (11) value TEXT Indexes person id INT(11) firstname VARCHAR(255) lastname VARCHAR(255) dob DATE Omanagerid INT (11) notes TEXT created TIMESTAMP Indexes projectperson prid INT(11) pid INT(11) rid INT (11) Indexes role id INT(11) label VARCHAR(255) Indexes project id INT(11) label VARCHAR(255) budget DOUBLE Indexes