Question

Consider the following 4 tables from a university database.

 

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:

        i.            Create Views that List Professors’ current Responsibilities & roles

information in the University.

(Name of View: Views_One)

      ii.            List columns name as Professor Number, Professor Full Name, Hire

Date and Job Description of those professors who have been part of the

university faculty for the last 6 months.

2. (Name View: Views_Two) Use Views_One as Nesting View

    iii.            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 those professors who are the part of university faculty from

last 6 months.

Hint:

Using (View named: Views_One)

Notes: