View the step-by-step solution to:

Consider the following relational data: Products: Pid Name Price Description p123 gizmo 22.99 Great p231 gizmoPlus 99.99 more features p312 gadget...

Consider the following relational data:
Products:
Pid Name Price Description
p123 gizmo 22.99 Great
p231 gizmoPlus 99.99 more features
p312 gadget 59.99 good value

Stores:
sid Name Phones
s323 Wiz 5551234
s521 Econo-Wiz 555-6543

Sells:
sid pid Markup
s323 p231 10%
s323 p123 25%
s323 p123 15%

((a) Write a XSD (Xml Schema Definition) file describing the following structure for the XML
file containing this data:
 there is one root element called products
 the products element contains a sequence of product subelements, one for each product in the database
 each product element contains one name, one price, and one description subelement, and a sequence of store subelements, one for each store that sells that product
 each store element contains one name, one phone, and one markup subelement.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question