Creating a table of xml documents

Assignment Help Data Structure & Algorithms

Reference no: EM1380104

Make a table of XML documents with a type of XML. Use a primary key (you can not use an XML type) so add a field of type INT that is an identity.
Insert many records into XML field in this new table. Use the following template:

Once these have been added, modify the structure of XML inside of your XML typed field to add another tag of <Material></Material>
Within the Features tag, use the "modify" function to make this happen.
Once this is complete, write an XQuery query using the value clause to return a single record.
CREATE TABLE script, the INSERT statements, the "modify" script, and the XQuery script.

Reference no: EM1380104

Questions Cloud

Different network connections : Use your laptop at public store to check your email and discuss all the different network connections involved in this operation.

Creating dataflow diagram : Think about the level of detail involved with creating a dataflow diagram, why should the narrative be prepared? Explain why do we need the questionnaire?

Question about structured wiring : Describe how properly installed structured wiring save the need to recable when new applications are added. Provide some examples of a project that required to be recabled because it was not properly installed structured wiring?

Analyze the code of ethics : Choose a Code of Ethics from your area of interest in your present work or future career and summarize this code and analyze the Code of Ethics you have chosen to determine what you think are its strengths and weaknesses. Explain why for both

Creating a table of xml documents : Make a table of XML documents with a type of XML. Use a primary key so add a field of type INT that is an identity. Insert many records into XML field in this new table.

Sql based question : In order to make the SQL select statements that would manufacture running summary files for reports of the above; how would you answer the questions below?

Find the weight range of normal onion bags : A packaging equipment is used to put onions into five pound bags. In fact the weights vary according to the normal distribution with expected price of average µ = 5.01 lb and standard deviation s = 0.05 lb.

Write an essay on one of topic : Write an Essay on one of topic given below: The impact of an individual's fortitude on self and others The impact of an individual's pursuit of ideals, An individual's response to circumstances beyond familiar experience, An individual's capacity ..

Shared activity, you will conduct a pestle analysis : For this Shared Activity, you will conduct a PESTLE analysis on your featured organisation and brand, which will become the focus of your Final Project. Imagine that the organisation you chose is in the decision phase of determining where to market n..

User Account

All Pages