☑Kizspy.me
4. (2 points) Write a trigger Trg_UpdateBookStatus to automatically update the book
status from "Available" to "Borrowed" when a book is assigned to a loan ticket. If
the book status is "Borrowed", then perform a rollback.
5. (2 points) Write a VIEW vw_OverdueBorrowHistory to display the list of borrowed
Book and add an extra column "Note" at the end of the list.
•
•
If the borrowed book has not been returned after the due date (ReturnDate <
GETDATE()), the "Note" column should display "Overdue".
Otherwise, it should display "Returned".
Zoom
+ 100%
End
Close
