数据库习题答案ch11

Section1

Exercise11.1.1

a)

b)

c)

Exercise11.1.2

Exercise11.1.3

Exercise11.1.4

Exercise11.1.5

Inthesemistructuredmodel,nodesrepresentdataelements,i.e.,entitiesratherthanentitysets.IntheUMLmodel,nodesofalltypesrepresentobjectsets,andthedataisnotrepresentedatall.

Section2

Exercise11.2.1

<?xmlversion="1.0"encoding="utf-8"standalone="yes"?>

<StarMovieData>

<StarstarID="cf"starredIn="sw">

<Name>CarrieFisher</Name>

<Address>

<Street>123MapleSt.</Street>

<City>Hollywood</City>

</Address>

<Address>

<Street>5LocustLn.</Stree>

<City>Malibu</City>

</Address>

</Star>

<StarstarID="mh"starredIn="sw">

<Name>MarkHamill</Name>

<Address>

<Street>456OakRd.</Street>

<City>Brentwood</City>

</Address>

</Star>

<MoviemovieID="sw"starsOf="cfmh">

<Title>StarWars</Title>

<Year>1977</Year>

</Movie>

</StarMovieData>

Exercise11.2.2

Title

Year

Length

Genre

GonewiththeWind

1939

231

Drama

StarWars

1977

124

SciFi

Wayne’sWorld

1992

95

Comedy

Figure2.3:TheRelationMovies

TherelationMoviesinXML:

<Movies>

<Movie>

<Title>GonewiththeWing</title>

<Year>1939</year>

<Length>231</length>

<Genre>Drama</genre>

</Movie>

<Movie>

<Title>StarWars</Title>

<Year>1977</year>

<Length>124</length>

<Genre>SciFi</genre>

</Movie>

<Movie>

<Title>Wayne’sWorld</Title>

<Year>1992</year>

<Length>95</length>

<Genre>Comedy</genre>

</Movie>

</Movies>

Exercise11.2.3

AnemptyelementcanberepresentedasaSubElementwhosechildIDvalueisnull(orapredefinedIDthatdoesnotmaptoanyelement).

Exercise11.2.4

DocRoot(docID,rootElementID)

Element(elementID,position)

ElementAttribute(elementID,name,value)

ElementValue(elementID,value)

SubElementOf(parentID,childID)

Section3

Exercise11.3.1

<?xmlversion="1.0"encoding="utf-8"standalone="yes"?>

<StarMovieData>

<StarstarID="cf"starredIn="swtesbrotjhahs">

<Name>CarrieFisher</Name>

<Address>

<Street>123MapleSt.</Street>

<City>Hollywood</City>

</Address>

<Address>

<Street>5LocustLn.</Street>

<City>Malibu</City>

</Address>

</Star>

<StarstarID="mh"starredIn="swtesbrotj">

<Name>MarkHamill</Name>

<Address>

<Street>456OakRd.</Street>

<City>Brentwood</City>

</Address>

</Star>

<StarstarID="hf"starredIn="swtesbrotjfw">

<Name>HarrisonFord</Name>

</Star>

<Starstarid="md"starredIn="tbi">

<Name>MattDamon</Name>

</Star>

<MoviemovieID="sw"starsOf="cfmhhf">

<Title>StarWars</Title>

<Year>1977</Year>

</Movie>

<MoviemovieID="tesb"starsOf="cfmhhf">

<Title>TheEmpireStrikesBack</Title>

<Year>1980</Year>

</Movie>

<MoviemovieID="rotj"starsOf="cfmhhf">

<Title>ReturnoftheJedi</Title>

<Year>1983</Year>

</Movie>

<MoviemovieID="fw"starsOf="hf">

<Title>Firewall</Title>

<Year>2006</Year>

</Movie>

<MoviemovieID="hahs"starsOf="cf">

<Title>HannahandHerSisters</Title>

<Year>1985</Year>

</Movie>

<MoviemovieID="tbi"starsOf="md">

<Title>TheBourneIdentity</Title>

<Year>2002</Year>

</Movie>

</StarMovieData>

Exercise11.3.2

<!DOCTYPEBank[

<!ELEMENTBANK(CUSTOMER*,ACCOUNT*)>

<!ELEMENTCUSTOMER(NAME,ADDRESS,PHONE,SSNO)>

<!ATTLISTCUSTOMER

custIdID

ownsIDREFS>

<!ELEMENTNAME(#PCDATA)>

<!ELEMENTADDRESS(#PCDATA)>

<!ELEMENTPHONE(#PCDATA)>

<!ELEMENTSSNO(#PCDATA)>

<!ELEMENTACCOUNT(NUMBER,TYPE,BALANCE)>

<!ATTLISTACCOUNT

acctIdID

ownedByIDREFS>

<!ELEMENTNUMBER(#PCDATA)>

<!ELEMENTTYPE(#PCDATA)>

<!ELEMENTBALANCE(#PCDATA)>

]>

Exercise11.3.3

<!DOCTYPESport[

<!ELEMENTSPORT(TEAM*,FAN*)>

<!ELEMENTTEAM(NAME,PLAYER+,COLOR+)>

<!ATTLISTTEAM

captainIDREF#REQUIRED

teamIDID#REQUIRED>

<!ELEMENTPLAYER(NAME)>

<ATTLISTPLAYER

playerIDID#REQUIRED>

<!ELEMENTFAN(NAME,COLOR*)>

<ATTLISTFAN

favoriteTeamsIDREFS

favoritePlayersIDREFS>

<!ELEMENTCOLOR(#PCDATA)>

<!ELEMENTNAME(#PCDATA)>

]>

Exercise11.3.4

<!DOCTYPEGenealogy[

<!ELEMENTGENEALOGY(PERSON*)>

<!ELEMENTPERSONEMPTY>

<ATTLISTPERSON

nameCDATA#REQUIRED

personIDID#REQUIRED

motherIDIDREF

fatherIDIDREF

childrenIDIDREFS>

]>

Exercise11.3.5

Relationschema:RELATIONNAME(attributelist)

<!DOCTYPERELATIONNAME[

<!ELEMENTRELATIONNAME(ROW*)>

<!ELEMENTROW(attributelist)>

foreachattributeTintheattributelist

<!ELEMENTT(#PCDATA)>

]

note:thesingularformoftherelationnameshouldusedinplaceofROW

Section4

Exercise11.4.1

<Movies>

<Movie>

<Title>StarWars</Title>

<Year>1977</Year>

</Movie>

</Movies>

<Movies>

<Movie>

<Title>StarWars</Title>

<Year>’77</Year><!--notaninteger-->

</Movie>

</Movies>

Exercise11.4.2

<?xmlversion="1.0"encoding="UTF-8"?>

<xs:schemaxmlns:xs="/2001/XMLSchema">

<xs:complexTypename="Movies">

<xs:sequence>

<xs:elementname="Movie"minOccurs="0"maxOccurs="unbounded">

<xs:complexType>

<xs:sequence>

<xs:elementname="Title"type="xs:string"/>

<xs:elementname="Year"type="xs:integer"/>

</xs:sequence>

</xs:complexType>

</xs:element>

</xs:sequence>

</xs:complexTy