Using the relations Teaching and Professor, create a viewof Transcript containing only rows corresponding to classes taught by John Smyth.Canthisview be used in a GRANT statement whose purpose is to allow Smyth to update student grades, but only those he has assigned? Explain.

What will be an ideal response?


```
CREATE VIEW SmythCourses(StudId, CrsCode, Semester, Grade) AS
SELECT T.StudId, T.CrsCode, T.Semester, T.Grade
FROM Teaching R, Transcript T, Professor P
WHERE T.CrsCode = R.CrsCode
AND T.Semester = R.Semester
AND R.ProfId = P.Id
AND P.Name = ’John Smyth’
```

The view SmythCourses allows Professor Smyth to see only those rows of Transcript corresponding to courses he has taught. However, since the view involves several tables it would not be updatable although a change to a grade visible in the view uniquely corresponds to a change in Transcript.

Computer Science & Information Technology

You might also like to view...

Although the UML can be used for business process modeling and requirements modeling, it is mainly used to support O-O system analysis and to develop object models.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

C++ provides ____________________ functions as a means to implement polymorphism in an inheritance hierarchy.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

The three options for beginning the animation on a selected slide element are On Click, With Previous, and After Previous.

a. true b. false

Computer Science & Information Technology

When ordering firewall rules, your should put deny rules ahead of allow rules.

a. true b. false

Computer Science & Information Technology