Database Reference
In-Depth Information
G. Write a stored procedure named ItemPriceChange that receives values for ItemID
and NewPriceUSD and sets the value of PriceUSD to NewPriceUSD for the row having
the given value of ItemID. Generate an error message if no row has the given value of
ItemID. Using your sample database, demonstrate that your stored procedure works.
h. Code two HTML/PHP pages to invoke the stored procedure created in part G. Add a
hyperlink to the MI Web page to access the HTML page. Using your sample database,
demonstrate that your page works.
I. Create an XML Schema Document for a row of the ITEM table. Use only simple ele-
ments, and use Figure 11-52 as an example.
J. Create an XML Schema document for a join of STORE and ITEM data. Assume that
the document has one store and from zero to many items purchased from that store.
Use Figure 11-58 as an example.
K. Write an SQL statement with FOR XML that will produce the document you created in
part J.
L. Create an XML Schema document that has all of the data for a given item. How many
multivalued paths does this schema have?
M. Explain how the XML Schema document you created in part L can be used to advantage
by Morgan Importing.
 
Search WWH ::




Custom Search