locked
XML and database RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1046621233 posted

    Good day

    I would like to know if someone can please explain to me,how this database would look like according to this xml data

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> </w:Compatibility> </w:WordDocument> </xml><![endif]-->

    <!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]-->

    <Request>

    <Number>1</Number>

    <DateTime>20080519122345</DateTime>

    <Active>True</Active>

    <Transaction>

    <Type>CL</Type>

     <Number>1234</Number>

    <DateTime>20080519122345</DateTime>

    </Transaction>

    <Transaction>

    <Type>RE</Type>

     <Number>1235</Number>

    <DateTime>20080519122345</DateTime>

    </Transaction> 

    <Provider>

    <Name>Discovery</Name>

    <Contact>

    <Name>A Smith</Name>

    <TelephoneNumber>012-1234567</TelephoneNumber>

    <EMailAdress>ddd@mail.com</EMailAdress>

    </Contact>

    </Provider>

    </Request>


    Thank you so incredibly much

    Regards

    Jake


    Thursday, April 18, 2013 4:42 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-1618234021 posted

    Roughly, the following structure:

    REQUEST
=========================
ReqNumber	int(pk)
requestdate	datetime
active		bit
ProviderID	int(fk)


RequestTransactions
=======================
TransactionNo	int(pk)
ReqNumber	int(.k)
TransactionType	smallint(fk)
TransactionDate	DateTime



TransactionType
===============
TransactionType	smallint(pk)
TypeTitle	varchar(2)


Provider
===========
ProviderID	int(pk)
Name		varchar(100)
ContactID	int(fk) 


ProviderContact
==================
ProvContactID	int
ProviderID	int(fk)
Name		varchar(100)
TelephoneNumber	varchar(100)
EMailAdress	varchar(100)



    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Thursday, April 18, 2013 8:36 AM