locked
XML and database RRS feed

  • Question

  • 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

  • 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