Information Technology Reference
In-Depth Information
Question 3.6
What is DTD-graph? How can one compare a DTD-graph with EER model?
Question 3.7
Show the steps of translating the following DTD-graph into DTD?
5RRW
$VVLJQ
(PSOR\HH
3URMHFW
(PSOR\HH
(PSOR\HHBQDPH
,'5()
,'5()
3URMHFW
3URMHFWBQDPH
Question 3.8
Translate the following relational schema into an XSD such that the selected XML
view is called “Factory” and the relevant relations under the root are relation Cat-
egory and the other navigable relations.
Relational Schemas:
5(/$7,21FDWHJRU\
LWHPBFRGH
QDPHGHVFULSW
5(/$7,21IHDWXUH
QDPH
GHVFULSWPXOWLYDOXHFDWHBLG
5(/$7,21IHDWXUHYDOXH
YDOXHBLG
YDOXHQDPH
5(/$7,21FDWDORJLWHP
LWHPBQR
FDWDBQDPHGHVFULSW
5(/$7,21SDUW
LWHPBQR
SDUWW\SH
5(/$7,21VXSSOLHU
LWHPBQR
QDPHDGGUHVV
5(/$7,21FDWDORJ
LWHPBFRGH
QDPHGHVFULSWVWDUWGDWHHQGGDWH
5(/$7,21SURGXFWEXQGOH,WHPBQRQDPHGHVFULSW
5(/$7,21SURGXFW
,WHPBFRGH
GHVFULSWXUOLWHPBQR
5(/$7,21VHUYLFH
,WHPBFRGH
GHVFULSWXQLWRIWLPH
5(/$7,21 XQLWRIWLPH
WLPHBFRGH
QDPHKRXUGD\ZHHNPRQWK
\HDU
5(/$7,21UHVRXUFH
LWHP
ORFQDPH,WHPBFRGH
5(/$7,21FDW
LWHPBFRGH
QDPH
where underlined words are primary key and words with “*” prefixes are foreign
keys.
Search WWH ::
Custom Search