Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  DTDs xml

Author  Topic  KazaX Starting Member 28 Posts Posted - 2008-11-17 : 18:59:24 Hi,there! Question is for XML interests only.... I have a database with tables Person(Name, Dept, ShoeSize) and Department(DName,Head,Tel).I need 3 DTDs that could be used to transmit the contents of the database to another site. The DTDs can use the tags such as Person, Department, Name, DName, etc that are used to define the relational schema, as well as other tags, such as Person-table as needed. The DTDs are described as follows: i. An element is constructed for each table and they are transmitted one after the other. ii. Person and Department tuples are intermixed, and there is an XML element for each tuple. iii. Each tuple is transmitted contiguously, but there are no XML elements corresponding to tuples or tables. Further if we have a Name and DName as keys for their respective tables and that Dept is non-null and references the foreign key DName. How can one construct a DTD in which Employee elements are inside the appropriate Department elements..... Hope not bored yet.... cheers