A business has a telephone directory that records the first and last name, telep

Question

A business has a telephone directory that records the first and last name, telephone number and email address of everyone working in the firm. Departments are the main organizing unit of the firm so the telophone directory is typicaly displayed in department order and shows for eaich department the contact phone and fax number and email address Using the following hierarchical data model PHONEBOOK DEPARTMENT EMPLOYEE firmname deptname empid emplname empphone empemail deptemail Create an XML file containing some directory data T T I Arial 3112p

Explanation / Answer

<?xml version="1.0" encoding="UTF-8"?>

<PHONEBOOK>

<FIRMNAME>My Firm 1</FIRMNAME>

<DEPARTMENT>

<DEPT_NAME>Dept1</DEPT_NAME>

<DEPT_PHONE>0512-22827836</DEPT_PHONE>

<DEPT_FAX>0512-238743434</DEPT_FAX>

<DEPT_EMAIL>xyz@gak.com</DEPT_EMAIL>

<EMPLOYEE>

<EMP_ID>123</EMP_ID>

<EMP_FNAME>Emp1</EMP_FNAME>

<EMP_LNAME>EmpL1</EMP_LNAME>

<EMP_PHONE>0849348343</EMP_PHONE>

<EMP_EMAIL>xyz@erd.com</EMP_EMAIL>

</EMPLOYEE>

<EMPLOYEE>

<EMP_ID>323</EMP_ID>

<EMP_FNAME>Emp2</EMP_FNAME>

<EMP_LNAME>EmpL2</EMP_LNAME>

<EMP_PHONE>056248343</EMP_PHONE>

<EMP_EMAIL>ere@erd.com</EMP_EMAIL>

</EMPLOYEE>

</DEPARTMENT>

<DEPARTMENT>

<DEPT_NAME>Dept2</DEPT_NAME>

<DEPT_PHONE>0412-22827836</DEPT_PHONE>

<DEPT_FAX>0343-238743434</DEPT_FAX>

<DEPT_EMAIL>xyz3@gak.com</DEPT_EMAIL>

<EMPLOYEE>

<EMP_ID>753</EMP_ID>

<EMP_FNAME>Emp5</EMP_FNAME>

<EMP_LNAME>EmpL5</EMP_LNAME>

<EMP_PHONE>0353548343</EMP_PHONE>

<EMP_EMAIL>45rer@erd.com</EMP_EMAIL>

</EMPLOYEE>

</DEPARTMENT>

</PHONEBOOK>

<PHONEBOOK>

<FIRMNAME>My Firm 2</FIRMNAME>

<DEPARTMENT>

<DEPT_NAME>Dept New</DEPT_NAME>

<DEPT_PHONE>054-22827836</DEPT_PHONE>

<DEPT_FAX>05463434</DEPT_FAX>

<DEPT_EMAIL>xyz23@gak.com</DEPT_EMAIL>

<EMPLOYEE>

<EMP_ID>12233</EMP_ID>

<EMP_FNAME>Emp1</EMP_FNAME>

<EMP_LNAME>EmpL1</EMP_LNAME>

<EMP_PHONE>0849348343</EMP_PHONE>

<EMP_EMAIL>xyz@erd.com</EMP_EMAIL>

</EMPLOYEE>

</DEPARTMENT>

</PHONEBOOK>

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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