Relational database from XML -
i trying learn create relational database schema given xml format. format follows
<product description:"cardigan sweater"> <catalog-item gender:"men's "> <item-number>qwz5 67 1 </item-number> <price>39.95</price> <size description:"medium"> <color>red</color> <color>burgundy</color> </size> <size description:" large "> <color>red</color> <color>burgundy</color> <lsize> </catalog-item> <catalog_item gender"'women's"> <item-number>rrx9 8 5 6</item-number> <price>42.5o</price> <size description:"medium"> <color>red</color> <color>navy</color> <color>burgundy</color> <color>black</color> </size> <size description:" large "> <color>burgundy</color> <color>black</color> </size> </catalog_item> </product>
any appreciated
it can translated following tables, in real world i'll define simpler structure (do have schema xml?).
table product {id_product, description} table catalogitem {id_catalogitem, id_product, gender, number, price} table catalogitemsize {id_catalogitemsize, id_catalogitem, description} table catalogitemsizecolor {id_catalogitemsizecolor, id_catalogitemsize, id_color} table color {id_color, description}
Comments
Post a Comment