Assignment title: Information


In Object-Relational Oracle DBMS, create the SAPS physical model. All keys must be carefully implemented. 2. Implement all the member methods as indicated in the model. 3. SAPS provides a flexible means of changing the cover of the books between soft and hard types in order to reduce the cost for customers. You are asked to write a subprogram or a user-defined method (preferably a procedure) to accomplish the following tasks. a. The method named Update_Cover will update the attribute of bindingType. Note that only books published by the publisher IDG can be updated with the cover type. b. Write a package SAPS that has a method of Update_Cover. Execute it via the package. 4. Write a method, in other words a subprogram Procedure Display_Book_Details, for the tasks below: a. List details of a book for a given ISBN/Title. The procedure accepts ONLY one argument, which can be interpreted as book ISBN or a title; retrieving information about chapters should use this argument only. ITEC870 / session 2 - 2014 5 Refer to Appendix I for the output layout and its requirements. b. Exceptions must be implemented when an ISBN or a title does not exist in the database. 5. The SAPS has decided to restructure their publication of journals in certain areas. You are now asked to write a subprogram Stored Procedure, namely Remove_Journal to remove journal papers that contain the word Clinical as one of the keywords. You need to think about how to handle the deletion of a journal if it contains a set of journal papers. Remove_Journal must take in only one argument of field and is executed via package SAPS.