From the book Database Systems by Carlos Coronel. Please fully explain your answ

Question

From the book Database Systems by Carlos Coronel. Please fully explain your answer. Thank you in advance!

The following is a sample XML document used to exchange "productlist" data. Can you come up with a corresponding DTD? Please make sure you put the "?", "*" and/or "+" in the right place.

<?xml version ="1.0"?>

<ProductList>

        <Product>

                       <P_CODE>23109-HB</P_CODE>

                       <P_INDATE>08/19/2009</P_INDATE>

                       <P_QOH>23</P_QOH>

                       <P_MIN>10</P_MIN>

                       <P_PRICE>5.95</P_PRICE>

                       <P_MANUFACTURER>

                                      <M_CODE>10173</P_MCODE>

                                      <M_POC>John Doe</P_POC>

                                      <M_Phone>(808) 123-4567</P_Phone>

                       </P_MANUFACTURER>

                       <P_MANUFACTURER>

                                      <M_CODE>29821</P_MCODE>

                                      <M_POC>Jane Doe</P_POC>

                                      <M_Phone>(808) 987-6543</P_Phone>

                       </P_MANUFACTURER>

        </Product>

        <Product>

                       <P_CODE>23114-AA</P_CODE>

                       <P_DESCRIPT>Sledge Hammer, 12 lb.</P_DESCRIPT>

                       <P_INDATE>09/01/2009</P_INDATE>

                       <P_QOH>8</P_QOH>

                       <P_MIN>5</P_MIN>

                       <P_PRICE>14.40</P_PRICE>

                       <P_MANUFACTURER>

                                      <M_CODE>29821</P_MCODE>

                                      <M_POC>Jane Doe</P_POC>

                                      <M_Phone>(808) 987-6543</P_Phone>

                       </P_MANUFACTURER>

        </Product>

</ProductList>

Explanation / Answer

There a lot of mistakes with the end tag's given in your xml code.

Actual XML:

<?xml version ="1.0"?>

<ProductList>

<Product>

<P_CODE>23109-HB</P_CODE>

<P_INDATE>08/19/2009</P_INDATE>

<P_QOH>23</P_QOH>

<P_MIN>10</P_MIN>

<P_PRICE>5.95</P_PRICE>

<P_MANUFACTURER>

<M_CODE>10173</M_CODE>

<M_POC>John Doe</M_POC>

<M_Phone>(808) 123-4567</M_Phone>

</P_MANUFACTURER>

<P_MANUFACTURER>

<M_CODE>29821</M_CODE>

<M_POC>Jane Doe</M_POC>

<M_Phone>(808) 987-6543</M_Phone>

</P_MANUFACTURER>

</Product>

<Product>

<P_CODE>23114-AA</P_CODE>

<P_DESCRIPT>Sledge Hammer, 12 lb.</P_DESCRIPT>

<P_INDATE>09/01/2009</P_INDATE>

<P_QOH>8</P_QOH>

<P_MIN>5</P_MIN>

<P_PRICE>14.40</P_PRICE>

<P_MANUFACTURER>

<M_CODE>29821</M_CODE>

<M_POC>Jane Doe</M_POC>

<M_Phone>(808) 987-6543</M_Phone>

</P_MANUFACTURER>

</Product>

</ProductList>

Corresponding DTD:

<?xml version="1.0" encoding="UTF-8"?>
<!-- DTD for passing the Product List -->
<!ELEMENT M_CODE ( #PCDATA ) >

<!ELEMENT M_POC ( #PCDATA ) >

<!ELEMENT M_Phone ( #PCDATA ) >

<!ELEMENT P_CODE ( #PCDATA ) >

<!ELEMENT P_DESCRIPT ( #PCDATA ) >

<!ELEMENT P_INDATE ( #PCDATA ) >

<!ELEMENT P_MANUFACTURER ( M_CODE, M_POC, M_Phone ) >

<!ELEMENT P_MIN ( #PCDATA ) >

<!ELEMENT P_PRICE ( #PCDATA ) >

<!ELEMENT P_QOH ( #PCDATA ) >

<!ELEMENT Product ( P_CODE | P_DESCRIPT | P_INDATE | P_MANUFACTURER | P_MIN | P_PRICE | P_QOH )* >

<!ELEMENT ProductList ( Product+ ) >

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.