Ask Question, Ask an Expert


Ask Computer Engineering Expert

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

• XML Introduction,
• Starting with XML (Lessons 1-7),
• Chapter 15: XML,
• XQL Tutorial,
• XQuery Tutorial,

XML Publishing. Consider the following relational data:


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


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


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

1 the development of a forensic lab for computers and

1. The development of a forensic lab for computers and mobile devices involves numerous specialized tools. Describe both hardware and software tools that might be utilized in such a lab. 2. Select ONE type of software to ...

Assignmentthis is not one long paper answer each of these

Assignment This is not one long paper! Answer each of these with at least 2 paragraphs each. 1. In addition to what we have learned from the course materials, there are other ways to categorize exceptions in Java. Go onl ...

Abc corp mines copper with xed costs of 060lb and variable

ABC Corp. mines copper, with ?xed costs of $0.60/lb and variable cost of $0.30/lb. The 1-year forward price of copper is $1.10/lb. The 1-year effective annual interest rate is 6.2%. One-year option prices for copper are ...

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

Databases and system architecture discussionsanswer all

Databases and System Architecture Discussions Answer all discusion topics Cables • Discuss different types of cables and the advantages/disadvantages of each type: o twisted pair o coaxial cable o fiber-optic. • Which on ...

Instructions1 research on the topic assigned by the

Instructions: 1. Research on the topic assigned by the professor, develop and present the following: a. A PowerPoint Presentation (2013) made of 8-10 slides based on the topic. Please make sure you save it on a flash dri ...

Unit homework1 write the syntax for a computer program to

Unit Homework 1. Write the syntax for a computer program to perform advanced loops. 2. Create a sub procedure and a function procedure. 3. Use a two-dimensional array to store, access, and search for elements within a co ...

1 in what ways is network design an iterative process why

1. In what ways is network design an iterative process? Why does the need for network documentation arise in many phases of a network design project? 2. When responding to an RFP, why is it important to pay attention to ...

Creating a new sales and inventory management system for

Creating a new sales and inventory management system for pet supply store. System allows 1) sales orders to be entered by clerk, 2) total price calculated and 3) inventory updated. Sales may be in person or over the phon ...

1 which cache design is better for each of these benchmarks

1. Which cache design is better for each of these benchmarks? Use data to support your conclusion. 2. Shared cache latency increases with the CMP size. Choose the best design if the shared cache latency doubles. Off -chi ...

  • 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

WalMart Identification of theory and critical discussion

Drawing on the prescribed text and/or relevant academic literature, produce a paper which discusses the nature of group

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