練習題題庫 [第十四章:XML與資料庫]
練習14-1
請解釋以下XML 片段的意義
<library_books>
<book>
<call_number> 423.21 8744 </call_number>
<title> 如何當個稱職的職場新鮮人</title>
<author>張大頭</author>
<author>李大炮</author>
<publish company = “想像出版社”, year = “民93 年”, place = “台北” />
<price>400</price>
</book>
</library_books>
 
練習14-2
請寫出練習14-1 的DTD。
 
練習14-3
以下XML 文件不是一個有效的文件,為什麼?
<?xml version = “1.0”?>
<!—A DTD example -->
    <!DOCTYPE library [
    <!ELEMENT library (branch+, book+)>
    <!ELEMENT branch (name, address)>
    <!ATTLIST branch branchID ID #REQUIRED>
    <!ELEMENT book (#PCDATA)>
    <!ATTLIST book inBranch IDREF>
    <!ELEMENT name (#PCDATA)>
    <!ELEMENT address ( #PCDATA )>
]>
<library>
    <branch branchID = “b1”>
        <name>理工圖書館</name>
        <address>理工大道一號</address>
    </branch>
    <branch branchID = “b2”>
        <name>文法商圖書館</name>
        <address>文管大道一號</address>
    </branch>
    <branch>
        <name>總圖書館</name>
    </branch>
    <book inBranch = “b2”>
        如何當個稱職的職場新鮮人
    </book>
    <book inBranch = “b3”>
        如何管理資料庫
    </book>
    <book inBranch = “b1”>
        JAVA 十天速成手冊
    </book>
    </library>
 
練習14-4
請寫出練習14-1 的相對應XML Schema 檔。