Question: Create DTD for below products.xml . code is refrred below Dog Shirt Gift Basket SJB Pet Boutique Something for every day of the week US$35.99

  1. Create DTD for below products.xml . code is refrred below

Dog Shirt Gift Basket

SJB Pet Boutique

Something for every day of the week

US$35.99

CAD$44.99

€26.79

1200, 1201, 1202, 1203, 1204, 1205, 1206

Car Curiosity Basket

SJB Pet Boutique

Playtime morning, noon, and night

US$15.99

CAD$18.82

€11.90

4430, 6500, 4434

Piggy Snuggle Basket

ACME

US$17.50

CAD$21.96

€13.03

3230, 3232

Dog Snuggle Basket

ACME

US$14.25

CAD$17.88

€10.61

3230, 3232, 3250

2.) Resolve naming collision by adding namepsaces

  • employeeList and personList - list schema
  • empId and second name - employee schema
  • first name - department schema
  • list schema - urn:corp:list
  • employee schema - urn:corp:emp
  • department schema - urn:corp:dep

?xml version="1.0" encoding="utf-8"?>

E0000001

Sales

John Smith

E0000002

Development

Ichiro Tanaka

E0000003

Development

Jiro Suzuki

E0000004

Administrative

Saburo Takahashi

3.) Create XSD for week-3/products.xml. code referred below

Dog Shirt Gift Basket

SJB Pet Boutique

Something for every day of the week

US$35.99

CAD$44.99

€26.79

1200, 1201, 1202, 1203, 1204, 1205, 1206

Car Curiosity Basket

SJB Pet Boutique

Playtime morning, noon, and night

US$15.99

CAD$18.82

€11.90

4430, 6500, 4434

Piggy Snuggle Basket

ACME

US$17.50

CAD$21.96

€13.03

3230, 3232

Dog Snuggle Basket

ACME

US$14.25

CAD$17.88

€10.61

3230, 3232, 3250

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Below is the code that may be needed. Below is the code that teacher required.Necessary requirements: You must make a diagram, and then you can use matlab to run it.DIAGRAM and MATLAB In this task,...

Q:

I have a .css file and a .xml file that I need to be combined so my code shows the style. Below is the .css file and my .xml file at the moment. xml file .css file This is what the outcome should...

Q:

Create an XML file products.xml and store information including the product id, product name, product quantity, and price of the product. Product id is an attribute while the other fields are...

Q:

Benjamin needs your help with a document that lists some of Map Finds For You's map products. Figure 2-32 shows the tree structure of Benjamin's XML document. U 0 Figure 2-3:2 Structure of the...

Q:

Problem description: In this Exam, you are requested to develop a website to make it easier for the grocery owners to order products through Al - Marai website. Also, Al - Marai can manage the order...

Q:

Use an editor (jEdit for xml) to create the XML, DTD and JSON In this exercise we shall explore a simplified use case scenario for XML: storing medical information. We are interested in storing basic...

Q:

REQUIREMENT: Submit an Assignment REPORT that shows your initial XML and DTD with at least 2 RECORDS and then proceed to modify the XML and DTD and clearly document your changes at each stop. You can...

Q:

Assignment: Manilow Aging Analysis 30 PY Manilow Company has asked you to help create year-end journal entries. They are currently reporting.co o in accounts receivable and they have want you a...

Q:

. In this exercise we shall explore a simplified use case scenario for XML: storing medical information We are interested in storing basic information about hospitals, doctors, patients and their...

Q:

I need a memo of these questions In the following exercises, you will set up database connectivity using MS Excel. 1 . Use MS Excel to connect to the Ch 0 2 _ InsureCo MS Access database using ODBC,...

Q:

Sammy has worked for a company with a retirement program, and today is retiring from her job with the amount of $ 115 in her retirement account. She decides to withdrawal an equal amount from this...

Q:

Shakira went bowling with her friends. She paid $3 to rent shoes and then $4.50 for each game of bowling. If she spent a total of $21, then How many games did Shakira bowl?

Q:

6 . Inventory financing solutions by Logistics Service providers ( LSPs ) typically work well only if: a . the cost of capital for the LSP is smaller than the cost of capital for the supplier b . the...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

Assessment of skills and interests.

Q:

Psychological, financial, and career counseling.

Q:

The manager must actively communicate with the job sharers and accept the fact that they might not be immediately available for consultation.