i want two views to create of following 4tables. PROJECT(proj_num,proj_name,prof

Question

   i want two views to create of following 4tables. PROJECT(proj_num,proj_name,prof_num) PROFESSOR(prof_num,prof_fname,prof_lname,prof_hiredate,job_code) JOB(job_code,job_description,job_chg_hour) ASSIGN(assign_num,assign_date,proj_num,prof_num,assign_hours) I have required to write two views. 1.(Name View: View_One) List columns as professor number, professsor full name,hiredate and job description of those professors who are a part offaculty from last 6 months. 2.(Name View: Views_Two) Use Views_One as nesting view List columns as professor full name, project name, projectassign date and assign hours where project assign date should notbe older than 4 months and this implies to those professors who area part of faculty from last 6 months.    i want two views to create of following 4tables. PROJECT(proj_num,proj_name,prof_num) PROFESSOR(prof_num,prof_fname,prof_lname,prof_hiredate,job_code) JOB(job_code,job_description,job_chg_hour) ASSIGN(assign_num,assign_date,proj_num,prof_num,assign_hours) I have required to write two views. 1.(Name View: View_One) List columns as professor number, professsor full name,hiredate and job description of those professors who are a part offaculty from last 6 months. 2.(Name View: Views_Two) Use Views_One as nesting view List columns as professor full name, project name, projectassign date and assign hours where project assign date should notbe older than 4 months and this implies to those professors who area part of faculty from last 6 months.

Explanation / Answer

Dear,

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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