Consider the following few relations of Academic systems. Here we have data base

Question

Consider the following few relations of Academic systems. Here we have data base design with little bit changes and is limited to four relations. PRO JEC T ( PROJNUM, PROJ_NAME, PROF_NUM) PROFESSOR ( PROF_NUM, PROFFNAME, PROFLNAME, PRO FHIRED ATE, JOB_CODE). JOB (JOB_CODE, JOBDESCRIPTTON, JOB_CHG_HOUR) ASSIGN (ASSIGNNUM, ASSIGNDATE, PROJ_NUM, PROF_NUM, ASSIGNHOURS) You are required to write the MEWS for the following situations. Create View's 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 function" like DATE ADD (datepart 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: Views_One), PROFESSOR, ASSIGN AND PROJECT relations here. Notes: Professor Full Name sha11 be from 1 Views named Views_Onee

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.