SQl views - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

SQl views

tayyabalitayyabali Posts: 5Member
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,
PROF_HIREDATE, JOB_CODE).
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
Sign In or Register to comment.