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

 

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

CREATE VIEW VEMPDEPTPROJ AS SELECT KID AS ID CONCAT KFirstN... View the full answer