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

What safety guidelines should businesses follow when using

What safety guidelines should businesses follow when using the internet? What legal protections should be created to assist business owners? Class, please share your thoughts as well.

1 what is the relationship between d-amps and amps2 what is

1. What is the relationship between D-AMPS and AMPS? 2. What is GSM? 3. What is the function of the CDMA in IS-95? 4. What are the three types of orbits? 5. Which type of orbit does a GEO satellite have? Explain your ans ...

A 2 gb ie 2 230nbspbyte memory system with 32-bit

A 2 GB (i.e., 2 * 2 30  byte) memory system with 32-bit addresses is used with a 4-way set associative cache that contains a total of 65536 lines (each line is 512 bytes in size).  How many different memory blocks could ...

1 why does the boyer-moore theorem prover perform induction

1. Why does the Boyer-Moore theorem prover perform induction only when the other five steps fail to simplify the formula? Why does it not try induction first? 2. Contrast the goals of the Gypsy Verification Environment w ...

Assuming buying a propertywhat is the 5 most important

Assuming buying a property: What is the 5 most important items you seek to understand/verify during your short due diligence period It is better to buy it and sell it yourself, or sold to REIT

A program contains a sequential part and the remaining part

A program contains a sequential part and the remaining part can be split evenly into independent tasks that can execute in parallel on the 16 available cores in the system. If a speedup of 15 is to be achieved using all ...

Compare and contrast intensive selective and exclusive

Compare and contrast intensive, selective, and exclusive distribution. Give an example of a product that normally would be distributed in this way for each type of market coverage?

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 ...

1 why was vbscript not very popular2 the biggest script

1. Why was VBScript not very popular? 2. The biggest script security threat has always been the acceptance of untrusted data. What is the best way for scripts to accept data and preserve the trust?

How do you make a module in ms acessattached is a database

How do you make a module in MS Acess Attached is a database with modules that were done for me I need directions , how and why these are built .I am trying to understand VBA and programing better. Attachment:- info262_rm ...

  • 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