Create a procedure ex7_supplier

Create a procedure ex7_supplier_update

Reference no: EM133258758

Create a procedure "ex7_supplier_update" that contains two input parameters. The first input parameter is a supplier_id attribute value that is used to delete the supplier from the supplier table. The second input parameter is also another supplier_id attribute value that is used to update the deleted supplier entry (of the first input parameter) in the product and purchase_order table with a new supplier value. Create a boolean function "ex7_supplier_exist" to determine if the two input parameter supplier_id attribute values exists before proceeding with the data manipulations. If the suppliers do not exist, then diaply a message "Invalid Suppliers. Run program unit again!." If the supplier does exist, then after completing the manipulations display the product_id attribute values that have the new updated supplier entry.

Reference no: EM133258758

Questions Cloud

Talk about your understanding of the mapreduce workflow : MTD207 St. Patrick's College Talk about your understanding of the MapReduce workflow with HDFS. You need to include: 1. Inputs and outputs of Map tasks.

How can you tell fake news stories from real ones : Recent years have seen a spike in misleading or false "news" and hoaxes that are shared as fact on social media. How can you tell fake news stories from real

Decleration of independence : According to Decleration of Independence, why did the Continental Congress write the Declaration of Independence and what does it say is purpose of government?

How the protocol implements its function : which the protocol belongs, the function of the protocol, and briefly explain how the protocol implements its function

Create a procedure ex7_supplier_update : Create a procedure "ex7_supplier_update" that contains two input parameters. The first input parameter is a supplier_id attribute value

Discuss the advantages and disadvantages of screening : Screening is the administration of measures or tests to distinguish individuals who may have a condition from those who probably do not have it

What constitutes appropriate role for judiciary : What constitutes an appropriate role for the judiciary? Some people argue that courts have become too powerful and that judges legislate from the bench

How big is the data portion of the cache in bytes : A memory cache using a 21-bits address with 14 bits for index and 5 bits for offset. How big is the data portion of the cache in bytes? memory cache using a 21

Explain the different between world space and search space : Explain the different between world space and search space with example?2- Describe the different between state graph and search tree?

User Account

All Pages