CS145 - Stanford - DTD Exercise, given an XML

Original XML is available here:

http://s3.amazonaws.com/dbclass-resources/docs/courses-noID.xml
http://s3.amazonaws.com/dbclass-resources/docs/courses-ID.xml
http://s3.amazonaws.com/dbclass-resources/docs/countries.xml

DTD written for the No Course-ID XML:

<!ELEMENT Course_Catalog (Department*)>
<!ELEMENT Department ( Title, Chair, Course+ ) >
<!ATTLIST Department Code NMTOKEN #REQUIRED >
<!ELEMENT Chair ( Professor ) >
<!ELEMENT Course ( Description | Instructors | Prerequisites | Title )* >
<!ATTLIST Course Enrollment NMTOKEN #IMPLIED >
<!ATTLIST Course Number ID #REQUIRED >
<!ELEMENT Description ( #PCDATA ) >
<!ELEMENT First_Name ( #PCDATA ) >
<!ELEMENT Instructors ( Lecturer | Professor )* >
<!ELEMENT Last_Name ( #PCDATA ) >
<!ELEMENT Lecturer ( First_Name | Last_Name | Middle_Initial )* >
<!ELEMENT Middle_Initial ( #PCDATA ) >
<!ELEMENT Prereq ( #PCDATA ) >
<!ELEMENT Prerequisites ( Prereq+ ) >
<!ELEMENT Professor ( First_Name | Last_Name | Middle_Initial )* >
<!ELEMENT Title ( #PCDATA ) >

DTD written for the Course-ID XML:

<!ELEMENT Course ( Title, Description? ) ><!ATTLIST Course Enrollment NMTOKEN #IMPLIED >
<!ATTLIST Course Instructors CDATA #REQUIRED >
<!ATTLIST Course Number ID #REQUIRED >
<!ATTLIST Course Prerequisites CDATA #IMPLIED >
<!ELEMENT Course_Catalog ( Department+ ) >
<!ELEMENT Courseref EMPTY ><!ATTLIST Courseref Number NMTOKEN #REQUIRED >
<!ELEMENT Department ( Course | Lecturer | Professor | Title )* ><!ATTLIST Department Chair NMTOKEN #REQUIRED >
<!ATTLIST Department Code NMTOKEN #REQUIRED >
<!ELEMENT Description ( #PCDATA | Courseref )* >
<!ELEMENT First_Name ( #PCDATA ) >
<!ELEMENT Last_Name ( #PCDATA ) >
<!ELEMENT Lecturer ( First_Name | Last_Name | Middle_Initial )* ><!ATTLIST Lecturer InstrID NMTOKEN #REQUIRED >
<!ELEMENT Middle_Initial ( #PCDATA ) >
<!ELEMENT Professor ( First_Name | Last_Name | Middle_Initial )* ><!ATTLIST Professor InstrID ID #REQUIRED >
<!ELEMENT Title ( #PCDATA ) >


DTD written for the Countries XML:

<!ELEMENT city ( name, population ) >
<!ELEMENT countries ( country+ ) >
<!ELEMENT country ( city | language )* ><!ATTLIST country area NMTOKEN #REQUIRED >
<!ATTLIST country name CDATA #REQUIRED >
<!ATTLIST country population NMTOKEN #REQUIRED >
<!ELEMENT language ( #PCDATA ) ><!ATTLIST language percentage NMTOKEN #REQUIRED >
<!ELEMENT name ( #PCDATA ) >
<!ELEMENT population ( #PCDATA ) >