1. Engineering
  2. Computer Science
  3. create a view using sql convention and the relations provided...

Question: create a view using sql convention and the relations provided...

Question details

Below is the relation schema for the Research University problem: Person(SSN, Age, Name) Professor(SSN, Rank, Specialty) GraduateStudent(SSN, DegreeProgram, AdvisorSSN, DepartmentNumber) Project(Number, StartDate, EndDate, Budget, SponsorOrganizationName) Department(Number, Name, Abbreviation, MainOffice, ChairmanSSN) WorksForProfessorSSN, DepartmentNumber, TimePercentage) WorksOn(GraduateStudentSSN, ProjectNumber, SupervisingProfessorSSN) You must support the following foreign keys ( means references): Professor(SSN)Person(SSN) Graduates tudent(SSN) → Person(SSN) GraduateStudent (AdvisorSSN)GraduateStudent(SSN) GraduateStudent(DepartmentNumber) Department(Number) WorksFor(ProfessorSSN) > Professor(SSN) WorksFor(DepartmentNumber) Department(Number) WorksOn(GraduateStudentSSN) GraduateStudent (SSN) WorksOn(ProjectNumber) > Project(Number) WorksOn(SupervisingProfessorSSN) Professor(SSN) Department(ChairmanSSN) Professor(SSN)

A view called ProjectSupervisors that shows the following information: the supervising professors SSN, name, rank and specialty, the name of the graduate student being supervised for a project, the project number, and is not a supervisor for a project, they should not be returned by this view c)

create a view using sql convention and the relations provided

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution