in reply to XML data to database

Yeah your post is pretty unreadable.

In general storing XML data in a relational dtabase is not straightforward. XML data is hierarchical which is different from the relational approach. Although most databases have XML import features/support nowadays.

You’re data is very simple though, so something like:

INSERT INTO Person VALUES (department,name,sex,age)