Question

need help with question 5.

3- Consider the following relation for published books: BOOK(Book_ title, Author_name, Book_type, List_price, Author_affil, Publisher) Suppose the following dependencies exist: Book_title à Publisher, Book_type Book_type à List_price Author_name à Author_affil a. What normal form is the relation in? Explain your answer? b. Apply normalization until you cannot decompose the relation further. State the reasons behind the decomposition. 4- Consider the above question, write a program in python to create xml file for the decomposed BOOK relation. 5. Generate some sample xml and the equivalent JSON file for question 3 relations. (You can use any data to generate the xml)

Answer 1

sample XML file :

<?xml version="1.0"?>
<Book>
   <title>Everyday Life</title>
    <author>random name</author>
    <book type="Guide">
    <price>30.00</price>
    <author affiliation="XYZ"></author>
    <publisher>abc Publishers</publisher>
</book>
<title>Best Pasta</title>
    <author>random name</author>
    <book type="COOKING">
    <price>40.00</price>
    <author affiliation="XYZ"></author>
    <publisher>abc Publishers</publisher>
</book>
<title>Haunted House</title>
    <author>random name</author>
    <book type="Horror">
    <price>60.00</price>
    <author affiliation="SRT"></author>
    <publisher>pqr Publishers</publisher>
</book>
<title>Fun with Science</title>
    <author>random name</author>
    <book type="Science">
    <price>20.00</price>
    <author affiliation="VBH"></author>
    <publisher>v publishers</publisher>
</book>

</Book>

publisher par Publishers m title Fun with Science 000 author Giada De Laurentiis Ó book 16 1 <?xml version="1.0"?> 2 - <Book <title>Everyday Life</title> <author>random name</author> <book type="Guide"> <price>30.00</price> Kauthor affiliation="XYZ"></author> <publisher>abc Publishers</publisher </book <title>Best Pasta</title> Kauthor>random name</author> <book type="COOKING"> <price>40.00</price> <author affiliation="XYZ"></author> <publisher>abc Publishers</publisher </book <title>Haunted House</title> <author>random name</author> <book type="Horror"> <price>60.00</price> Kauthor affiliation="SRT"></author> <publisher>par Publishers</publisher </book> <title>Fun with Science</title> <author>Giada De Laurentiis</author> <book type="Science"> <price>20.00</price> Kauthor affiliation="VBH"></author> <publisher> publishers</publisher> </book 31 32 </Rook @type: Science price 20.00 author @affiliation: VBH 23 25 publisher v publishers

Equivalent JSON File: book.json

[
{
    "title": "Everyday Life",
    "author": "random name",
    "type": "Guide",
    "price": 30.00,
    "author_affiliation": "XYZ",
    "publisher": "abc Publisher"
},
{
   "title": "Best Pasta",
    "author": "random name",
    "type": "Cooking",
    "price": 40.00,
    "author_affiliation": "XYZ",
    "publisher": "abc Publisher"
},
{
"title": "Haunted House",
    "author": "random name",
    "type": "Horror",
    "price": 60.00,
    "author_affiliation": "SRT",
    "publisher": "pqr Publisher"
},
{
"title": "Fun with Science",
    "author": "random name",
    "type": "Science",
    "price": 20.00,
    "author_affiliation": "VBH",
    "publisher": "v Publisher"
}
]