Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Computer Engineering Expert

In addition to the textbook chapters, you may use any online reference such as:

• XML Introduction, http://www.w3schools.com/xml/xml_whatis.asp
• Starting with XML (Lessons 1-7), http://www.codehelp.co.uk/html/first.html
• Chapter 15: XML, http://docstore.mik.ua/orelly/web2/xhtml/ch15_01.htm
• XQL Tutorial, http://www.ibiblio.org/xql/xql-tutorial.html
• XQuery Tutorial, http://homepages.inf.ed.ac.uk/wadler/papers/xquery-tutorial/xquery-tutorial.pdf

XML Publishing. Consider the following relational data:

Products:

pid     Name         Price     Description
323    gizmo        22.99    great
233    gizmoplus  99.99    morefeatures
312    gadget      59.99    goodvalue

Stores:

Sid       Name          Phone
s282    Wiz             555-1234
s521    Econo-Wiz  555-6543

Sells:

Pid    Markup    sid
323    10%    s521
233    25%    s282
233    15%    s521

A) Use and submit a text file (.txt) to prepare your information for the following. You want to export this data into an XML file. prepare a Document Type Definition (DTD)describing this structure for the XML file.

a) There is one root element called products

b) The products element contains a sequence of product sub-elements, one for each product in the database

c) Each product element contains one name, one price, and one description sub-element, and a sequence of store sub-elements, one for each store that sells that product.

d) Each store element contains one name, one phone, and one markup sub-element.

B) At the bottom of your .txt file, use an underscore line (_________) to separate the answer to this problem from B. above.

Assuming that you have an XML document with the structure given in A., prepare an XQuery expression that returns the names and prices of all products that are sold at least at one store with a markup of 25%.

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M9268

Have any Question? 


Related Questions in Computer Engineering

Another form of comb filter is given by the transfer

Another form of comb filter is given by the transfer function H(z)=1+ z -L For this problem, let L = 6. (a) Find the filter's impulse response h[n]. (b) Determine a canonical realization of this filter. (c) Find and plot ...

Sql research paperwrite a 4 page technical paper about the

SQL Research Paper Write a 4 page technical paper about the following topic: Topic : NOSQL as a mechanism for storage and retrieval of data. Your paper may include any or some of the following themes: • It must have a te ...

1 the maximum window size of the tcp was originally

1. The maximum window size of the TCP was originally designed to be 64 KB (which means 64 × 1024 = 65,536 or actually 65,535). Can you think of a reason for this? 2. What is the maximum size of the TCP header? What is th ...

Describe the concepts of confidentiality integrity and

Describe the concepts of confidentiality, integrity, and availability (C-I-A), and explain each of the seven domains of a typical IT infrastructure. Summarize the threat triad, and explain how security personnel can main ...

Fisch white and pooch 353 define four levels of log

Fisch, White, and Pooch [353] define four levels of log sanitization. a. Simple sanitization, in which all information except the commands issued by an intruder are deleted b. Information-tracking sanitization, in which ...

Create a foreign agent advertisement message using 1672 as

Create a foreign agent advertisement message using 1672 as the sequence number and a lifetime of 4 hours. Select your own values for the bits in the code field. Use at least three care-of addresses of your choice. Calcul ...

Assignmentcomp software apps healthcaremedical practice

Assignment Comp Software Apps Healthcare Medical Practice Management Software Assignment: 1. List the advantages of computerization of the medical office 2. List the disadvantages of computerization of the medical office ...

Construct a 3-bit counter using three d flip-flops and a

Construct a 3-bit counter using three D flip-flops and a selection of gates. The inputs should consist of a signal that resets the counter to 0, called reset, and a signal to increment the counter, called inc. The output ...

1 why is a methodology important in the implementation of

1. Why is a methodology important in the implementation of information security? How does a methodology improve the process? 2. Which members of an organization are involved in the security system development life cycle? ...

We can define the bandwidth-delay product in a network as

We can define the bandwidth-delay product in a network as the number of packets that can be in the pipe during the round-trip time (RTT). What is the bandwidth-delay product in each of the following situations? a. Bandwi ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen