This is for SQL:

Create a new table in your database, with your initials as suffix,

e.g. myxmlRR

It should have three columns:

id is an integer, not null and is the primary key.

name is a variable length string , max length of 30

document is an xml document.

1. Create this table (@10 pts)

2. Declare a variable to hold the xml document, and Set that variable with the document shown below PLUS, add in a last name element for each Person, where Jos last name is Tiger and Kims last name is Wolf.

Dont forget the tick marks! (@20 pts)

'

Jo

Kim

'

3. Insert into the table where id = 10, and name = xmlstorage, and the xml document using your xml variable (@ 10 pts)

4. Select all the elements of that row, and, Show the expanded selected result ( as in the guide). That is, this

should show the expanded xml document you previously inserted...(@10 pts)