Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

https://drive.google.com/file/d/1-WLRqaaz8d_xjd44K7bWnVgJ6UW8n7kq/view?usp=sharing https://drive.google.com/file/d/1peg4sgyeyTl3E_kzb3itIyi1XT0Jf0Ft/view?usp=sharing Open orders.xml document holding data regarding customers who placed orders for a store Figure 1 shows the customers vocabulary structure and Figure 2

image text in transcribedimage text in transcribed

https://drive.google.com/file/d/1-WLRqaaz8d_xjd44K7bWnVgJ6UW8n7kq/view?usp=sharing

https://drive.google.com/file/d/1peg4sgyeyTl3E_kzb3itIyi1XT0Jf0Ft/view?usp=sharing

Open orders.xml document holding data regarding customers who placed orders for a store Figure 1 shows the customers vocabulary structure and Figure 2 shows a description of the elements and attributes used for the customers vocabulary Open orders.xsd document and create a schema that will validate the data entered into orders.xml document. 1. 2. customers customer custID title address email orders order orderID orderB orderDate items temNumber itemPrice saleltem itemQt Figure 1: Structure of the customers vocabulary Element or Attribute The root element The collection of information about a customer The ID number of the customer with the format cust###, where # is a digit The name of the customer The title for the customer (Mr., MS., or Mrs.) The address for the customer The phone number for the customer The email address for the customer The collection of information on order The collection of information on an individual order custID title addres8 phone ena11 order Element or Attribute The root element The collection of information about a customer The ID number of the customer with the format cust###, where # is a digit The name of the customer The title for the customer (Mr, M., or Mrs.) The address for the customer The phone number for the customer The email address for the customer The collection of information on orders The collection of information on an individual order The ID number of the order with the format or, where is a digit The ID number of the customer who placed the order The date the order was placed The collection of information on items The collection of information on a specific itenm The item number of the item ordered The price paid for the itenm Whether the itemPrice was a sale price (x or N) The quantity of the item ordered custID title addres8 phone ena11 orders order orderID orderBy orderDate i tens Iten itenprice saleltem tenoty Figure 1: The customers vocabulary

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Application Development And Administration

Authors: Michael V. Mannino

4th Edition

0615231047, 978-0615231044

More Books

Students also viewed these Databases questions

Question

Different types of Grading?

Answered: 1 week ago

Question

Explain the functions of financial management.

Answered: 1 week ago

Question

HOW MANY TOTAL WORLD WAR?

Answered: 1 week ago

Question

Discuss the scope of financial management.

Answered: 1 week ago