Consider the following few relations of Academic systems.
Here we have data base design with little bit changes and is limited
to four [size=2]relations.
[color=Green][size=3][b]PROJECT ( PROJ_NUM, PROJ_NAME, PROF_NUM)
PROFESSOR ( PROF_NUM, PROF_FNAME, PROF_LNAME,
JOB (JOB_CODE, JOB_DESCRIPTION, JOB_CHG_HOUR)
ASSIGN (ASSIGN_NUM, ASSIGN_DATE, PROJ_NUM, PROF_NUM,ASSIGN_HOURS)[/b][/size][/size][/color]
A. You are required to write the VIEWS for the following situations.
Create Views that List Professors