Question

Create the following: (1) a CREATE VIEW statement that defines a view named FacultyCampus that returns three columns: FirstName, LastName, and Term for faculty that are teaching during the semester, along with the terms they teach, and (b) a SELECT statement that returns all of the columns in the view, sorted by Term, of faculty members who are teaching during the semester.

Answer 1

a-

CREATE VIEW FacultyCampus

AS

SELECT F.FirstName, F.LastName, C.Term

FROM Faculty F, Course C

WHERE C.Faculty_ID=F.Faculty_ID

b-

SELECT *

FROM FacultyCampus

ORDER BY Term DESC

Step-by-step explanation:

As the database table creation is not given, the question is searched and the remaining portion of the question is found which indicates the table created. This is attached:

From the created database, the view is created as follows:

a-

CREATE VIEW FacultyCampus

AS

SELECT F.FirstName, F.LastName, C.Term

FROM Faculty F, Course C

WHERE C.Faculty_ID=F.Faculty_ID

Here first the view is created in which the selection of the first name from faculty table, last name from faculty table, and term from the Course table is made where the values of Faculty ID in course table and Faculty ID of Faculty table are equal.

The select query is as follows:

b-

SELECT *

FROM FacultyCampus

ORDER BY Term DESC

Here the selection of all the columns from the view is made and are ordered by the term in the descending form.