(Solved) : Please Provide Sql Queries Following Create New Table Database Initials Suffix Eg Myxmlrr Q28863359 . . . .

Please provide the SQL queries for the following:

Create a new table in your database, with your initials assuffix,

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 Setthat variable with the document shown below PLUS,add in a last name element for each Person, where Jo’s last name is“Tiger” and Kim’s last name is “Wolf”.

Don’t forget the tick marks! (@20 pts)

‘<?xml version=”1.0″ encoding=”UTF-8″?>

<People>

<Person><FirstName>Jo</FirstName></Person>

<Person><FirstName>Kim</FirstName></Person>

</People>’

Hint, here is the way