Database Reference
In-Depth Information
Figure 11-53
Continued
(b) Graphical representation of the XML Schema
"[POYHUVLRQ HQFRGLQJ 87)"!
&XVWRPHU
[POQV[VL
KWWSZZZZRUJ;0/6FKHPDLQVWDQFH
[VLQR1DPHVSDFH6FKHPD/RFDWLRQ
&?LQHWSXE?ZZZURRW?'%3?95*?'%3H)LJXUH$[VG
!
&XVWRPHU,'
!
&XVWRPHU,'
!
/DVW1DPH
!
-DQHV
/DVW1DPH
!
)LUVW1DPH
!
-HIIHU\
)LUVW1DPH
!
$GGUHVV
!
6WUHHW
!
:(OP6W
6WUHHW
!
&LW\
!
5HQWRQ
&LW\
!
6WDWH
!
:$
6WDWH
!
=LS3RVWDO&RGH
!
=LS3RVWDO&RGH
!
&RXQWU\
!
86$
&RXQWU\
!
$GGUHVV
!
3KRQH
!
$UHD&RGH
!
$UHD&RGH
!
3KRQH1XPEHU
!
3KRQH1XPEHU
!
3KRQH
!
(PDLO$GGUHVV
!
-HIIHU\-DQHV#VRPHZKHUHFRP
(PDLO$GGUHVV
!
&XVWRPHU
!
(c) Schema-Valid XML Document
in the CUSTOMER table. However, in the AddressType complexType, {Street, City, State,
ZipPostalCode} are required (NOT NULL). Similarly, in the PhoneType complexType,
{AreaCode, Phone Number} are required. These conditions can be read as “IF there is Address
data for a customer, it MUST include the street address, city, state, and zip/postal code,” and
“IF there is Phone data for a customer, it MUST include both the area code and phone number.”
Search WWH ::
Custom Search