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

A certain program consists of three independent parts a b

A certain program consists of three independent parts A, B and C each of which can execute in parallel on a separate processor. Part A requires 78 billion cycles to complete, part B requires 40 billion cycles to complete ...

A company publishes the design of its security software

A company publishes the design of its security software product in a manual that accompanies the executable software. a. In what ways does this satisfy the principle of open design? In what ways does it not? b. Given tha ...

Identify ten validation tests and techniques used to

Identify ten validation tests and techniques used to enhance the validity of data input; be sure to give an example of each in your discussion. How are these tests handled? This assignment must be a neat, professional pr ...

Recall that criteria creep is the process of refining

Recall that "criteria creep" is the process of refining evaluation requirements as the industry gains experience with them, making the evaluation criteria something of a moving target. This issue is not confined to the T ...

Design an algorithm that reads lines of text reformats it

Design an algorithm that reads lines of text, reformats it and writes it out in pages of two columns (each forty characters wide) separated by a 10-space gap. The first column of the output should correspond to the first ...

Give your definition of the word machine do you believe

Give your definition of the word machine. Do you believe that humans are machines? Whatever your belief (perhaps it is either yes, no, maybe, or not entirely), use your definition and evidence about the various abilities ...

Calculate the total number of bits required for the cache

Calculate the total number of bits required for the cache listed above, assuming a 32-bit address. Given that total size, find the total size of the closest direct-mapped cache with 16-word blocks of equal size or greate ...

Show that there is no speckle in images obtained by an

Show that there is no speckle in images obtained by an ideal imaging system. Show that, for a practical imaging system, the speckle size measured by its correlation distance can be used to estimate the resolution (that i ...

1 can we have a data-transfer connection without a control

1. Can we have a data-transfer connection without a control connection in FTP? Explain. 2. Assume we need to download an audio using FTP. What file type should we specify in our command? 3. Both HTTP and FTP can retrieve ...

1 what was important about rand report r-6092 who decides

1. What was important about Rand Report R-609? 2. Who decides how and when data in an organization will be used or controlled? Who is responsible for seeing that these wishes are carried out? 3. Who should lead a securit ...

  • 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