Create a view that lists the ISBN and title for each book in inventory along

Create a view that lists the isbn and title for each

This preview shows page 1 - 2 out of 2 pages.

5. Create a view that lists the ISBN and title for each book in inventory along with the name and phone number of the person to contact if the book needs to be reordered. Name the view REORDERINFO. 6. Try to change the name of a contact person in the REORDERINFO view to your name. Was an error message displayed when performing this step? If so, what was the cause of the error message? UPDATE reorderinfo SET contact = ‘YOUR NAME’ WHERE contact = ‘RENEE SMITH’ SET contact = 'YOUR NAME' 7. Select one of the books in the REORDERINFO view and try to change its ISBN.Was an error message displayed when performing this step? If so, what was the cause of the error message?
Image of page 1
SELECT books FROM REORDERINFO SET ISBN = ‘CHANGE’ 8. Delete the record in the REORDERINFO view containing your name.(If you weren’t able to perform #6 successfully, delete one of the contacts already listed in the table.) Was an error message displayed when performing this step? If so, what was the cause of the error message? DELETE contact FROM REORDERINFO 9. Issue a rollback command to undo any changes made with the preceding DML operations. ROLLBACK; 10. Delete the REORDERINFO view. DELETE REORDERINFO;
Image of page 2

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture