corresponding to the entity added in the diagram. The statement needs to show
maximum data constraints on the table fields. Enter 5 appropriate rows of data for the table just created. Add foreign key constraints to related tables if any (Othertables are already available).
Note: The AuthorsID should be set to auto-increment (use the IDENTITY(1,1)keyword when creating the table) and "Insert a total of 5 rows of data into the Authors table with auto-incremented AuthorsID, and then create the foreign key relationship."
3. (2 points) Write a stored procedure with an input parameter BorrowerID that displays information about all borrowed books and also lists the books that have not been returned by that specific borrower.
4. (2 points) Write a trigger that executes when a row is inserted into the DetailLoans table. If the number of AvailableCopies is 0, it should display a message that the book is out of stock and cannot be borrowed. Otherwise, it should decrement the AvailableCopies by one.
+ 134%
Zoom
Close
