Question: SQL. I need the answer fast please (online assignment) Thank you. Consider the following relations: Book (bookId, bookTitle, publishingYear, NumOfCopies, publisher) Student (studentId, studentName, address,

SQL. I need the answer fast please (online assignment) Thank you. ConsiderSQL. I need the answer fast please (online assignment) Thank you.

Consider the following relations: Book (bookId, bookTitle, publishingYear, NumOfCopies, publisher) Student (studentId, studentName, address, age, gender, limitBorrowing) Borrowing (studentId, bookId, borrowDate, returnDate) Answer the following questions: (10 points per question) 1. Create a trigger in SQL which calculates the number of rows that were inserted till now in Book table. 2. Create a trigger that whenever an insert, update, or delete operation occurs on the Book table, a row is added to the BookAuditLog table recording the date, user and action done on Book table (whether inserting, updating or deleting). Assume that the table BookAuditLog is already created as follows. CREATE TABLE BookAuditLog (audit Date DATE, auditUser VARCHAR2(20), auditAction VARCHAR2(20))

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!