Consider the following few relations of Academic systems, four relations. PROJEC

Question

Consider the following few relations of Academic systems, four relations. 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) You are required to write the VIEWS for the following situations. Create Views that List Professors' current Responsibilities & roles information in University. (Name View: Views One) List columns name as Professor Number, Professor Full Name, Hire Date and Job Description of those professors who are the part of university faculty from last 6 months. Hint: using aggregate functions like DATE ADD Cdatepart, number, date ) (Name View: Views Two) Use Views One as Nesting View List columns name as Professor Full Name Project Name, Project Assign Date and Assign Hours Where Project Assign Date shouldn't be older than 4 months and this implies to those professors who are the part of university faculty from last 6 months. Hint: Using (View named: ViewreOne). PROFESSOR, ASSIGN AND PROJECT relations ere. Notes: Professor Full Name shall be from 1st Views named Views One|

Explanation / Answer

Dear,

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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