أرجوووو المساااااعدة !

Develop XML and XSL documents to convert database tables’ representation into XML data. The database tables should be created using Access or Excel and represent information about borrowers and library books. Restrict the number of table elements (e.g. the number of the rows in the tables) to 15 rows. The first table contains information about the books a particular borrower has borrowed from the library with the following information: borrower’s id (a unique 5-digits whole number), borrower’s last and first name, a library number of a borrowed book (a unique identifier 5 characters long, containing letters and digits). A borrower could borrow 5 books at a time only. The second table contains the following information: a library number (same as above), book name, authors (one or more with family name and initial for the first name), title, loan type (ordinary, reference or long loan). Your task is to design and develop corresponding XML and XSL documents for each table.

You will have to complete the following tasks for each table:

1.1. Creating XML documents

Write an XML document to represent the information from a table.

You have to decide on how to represent the information for each element by answering the following questions.

What is the root element?

What is the structure of the sub-elements?

Will you use attributes or sub-elements?

1.2. Displaying XML documents using XSL documents

Write an XSL document to display the XML document in an HTML format.

<H1 style="MARGIN: 0in 0in 0pt"> </H1>1.3. Documentation

The documentation should be in the format of a formal (e.g. word processed) report. It should include the following elements:

• XML documents. Include the XML documents and the corresponding Access or Excel database tables.
  
• XSL documents. Include also screenshots of the corresponding HTML output in a browser.
  

<H3 style="MARGIN: 0in 0in 0pt; TEXT-ALIGN: justify"> </H3>