PROJECT( PROJ_NUM, PROJ_NAME,PROF_NUM) PROFESSOR (PROF_NUM, PROF_FNAME, PROF_LNA

Question

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)

A. You are required towrite the VIEWSfor the following situations.

Create Viewsthat List Professors’ current Responsibilities &roles

information inUniversity.

1. (NameView: Views_One)

List columnsname as Professor Number, Professor Full Name, Hire

Date and JobDescription of those professors who are the part of

universityfaculty from last 6 months.

Hint:using aggregate functionslike DATEADD (datepart,number,

date )

2. (NameView: Views_Two) UseViews_One as Nesting View

List columnsname as Professor Full Name

1

, Project Name,Project

Assign Date andAssign Hours

Where ProjectAssign Date shouldn’t be older than 4 months and this

implies tothose professors who are the part of university facultyfrom

last 6months.

Hint:

Using (Viewnamed: Views_One) , PROFESSOR, ASSIGN AND PROJECT

relationshere.

Notes:

1. ProfessorFull Name shall be from 1st Views namedViews_Onee

Explanation / Answer

Dear,

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

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