database primary keys in XML Schema

["Markus Seibold" <Markus.Seibold@gmx.net>]

Hello everybody,

I am developing a XML Schema which should function as an interface to a
relational database.
I have problems with how to design the primary keys in XML Schema.

1.) When I insert data via XML instance documents the first time, I cannot
specify a primary key in my XML instance document because the database
automatically creates an auto-increment key. Correct?

2.) What if I, for example, want to insert a city in a geography database
(the database has a Country and a City table; 1:n relationship). When inserting
a city, how can I specify to which country the city belongs? I needed to
know the database primary key for the country, wouldn't I and add this key as an
attribute to the city in my instance document?
What other solutions do exist?

This issue cost me alot of time so far and I would really appreciate any
help!

Thanks a lot, Markus