code 14.1.3.dtd.txt

开发web_xml

<!ELEMENT EMPLOYEE (
EMPLOYEE.NUM? , 
EMPLOYEE.FNAME , 
EMPLOYEE.LNAME , 
EMPLOYEE.HIRE_DATE , 
EMPLOYEE.TERM_DATE? )>

<!ATTLIST EMPLOYEE pkey_id ID #REQUIRED
e-pkey NMTOKEN #FIXED 'EMPLOYEE.NUM' >

<!ELEMENT EMPLOYEE.NUM (#PCDATA )>

<!ATTLIST EMPLOYEE.NUM e-dtype NMTOKEN #FIXED 'int' >

<!ELEMENT EMPLOYEE.FNAME (#PCDATA )>

<!ATTLIST EMPLOYEE.FNAME e-dtype NMTOKEN #FIXED 'string'
e-dSize NMTOKEN #FIXED '32' >

<!ELEMENT EMPLOYEE.LNAME (#PCDATA )>

<!ATTLIST EMPLOYEE.LNAME e-dtype NMTOKEN #FIXED 'string'
e-dSize NMTOKEN #FIXED '32' >

<!ELEMENT EMPLOYEE.HIRE_DATE (#PCDATA )>

<!ATTLIST EMPLOYEE.HIRE_DATE e-dtype NMTOKEN #FIXED 'date' >

<!ELEMENT EMPLOYEE.TERM_DATE (#PCDATA )>

<!ATTLIST EMPLOYEE.TERM_DATE e-dtype NMTOKEN #FIXED 'date' >


<!ELEMENT PERF_REVIEW (
PERF_REVIEW.EMP_NUM , 

PERF_REVIEW.REVIEW_DATE , 

PERF_REVIEW.REVIEW )>

<!ATTLIST PERF_REVIEW PERF_REVIEW.EMP_NUM_idref IDREF #REQUIRED >

<!ELEMENT PERF_REVIEW.EMP_NUM (#PCDATA )>

<!ATTLIST PERF_REVIEW.EMP_NUM e-dtype NMTOKEN #FIXED 'int'
e-fkey NMTOKEN #FIXED 'EMPLOYEE.NUM' >

<!ELEMENT PERF_REVIEW.REVIEW_DATE (#PCDATA )>

<!ATTLIST PERF_REVIEW.REVIEW_DATE e-dtype NMTOKEN #FIXED 'date' >

<!ELEMENT PERF_REVIEW.REVIEW (#PCDATA )>

<!ATTLIST PERF_REVIEW.REVIEW e-dtype NMTOKEN #FIXED 'string'
e-dSize NMTOKEN #FIXED '50' >


<!ELEMENT COMP_CHANGE (
COMP_CHANGE.EMP_NUM ,

COMP_CHANGE.REVIEW_DATE? , 

COMP_CHANGE.EFF_DATE , 

COMP_CHANGE.SALARY )>

<!ATTLIST COMP_CHANGE COMP_CHANGE.EMP_NUM_idref IDREF #REQUIRED >

<!ELEMENT COMP_CHANGE.EMP_NUM (#PCDATA )>

<!ATTLIST COMP_CHANGE.EMP_NUM e-dtype NMTOKEN #FIXED 'int'

e-fkey NMTOKEN #FIXED 'EMPLOYEE.NUM' >

<!ELEMENT COMP_CHANGE.REVIEW_DATE (#PCDATA )><!ATTLIST COMP_CHANGE.REVIEW_DATE e-dtype NMTOKEN #FIXED 'date' >

<!ELEMENT COMP_CHANGE.EFF_DATE (#PCDATA )><!ATTLIST COMP_CHANGE.EFF_DATE e-dtype NMTOKEN #FIXED 'date' >

<!ELEMENT COMP_CHANGE.SALARY (#PCDATA )><!ATTLIST COMP_CHANGE.SALARY e-dtype NMTOKEN #FIXED 'int' >

DTD with Columns as Attributes
<!ELEMENT EMPLOYEE EMPTY>

<!ATTLIST EMPLOYEE pkey_id ID #REQUIRED
NUM CDATA #REQUIRED

FNAME CDATA #REQUIRED

LNAME CDATA #REQUIRED

HIRE_DATE CDATA #REQUIRED

TERM_DATE CDATA #IMPLIED

e-pkey NMTOKEN #FIXED 'NUM'

a-dtype NMTOKENS 'NUM int

FNAME string

LNAME string

HIRE_DATE date

TERM_DATE date'

a-dSize NMTOKENS 'FNAME 32 LNAME 32' >

<!ELEMENT PERF_REVIEW EMPTY>

<!ATTLIST PERF_REVIEW PERF_REVIEW.EMP_NUM_idref IDREF #REQUIRED

EMP_NUM CDATA #REQUIRED

REVIEW_DATE CDATA #REQUIRED

REVIEW CDATA #REQUIRED

a-dtype NMTOKENS 'EMP_NUM int

REVIEW_DATE date

REVIEW date'

a-fkey NMTOKENS 'EMP_NUM EMPLOYEE.NUM'

a-dSize NMTOKENS 'REVIEW 50' >

<!ELEMENT COMP_CHANGE EMPTY>

<!ATTLIST COMP_CHANGE COMP_CHANGE.EMP_NUM_idref IDREF #REQUIRED

EMP_NUM CDATA #REQUIRED

REVIEW_DATE CDATA #IMPLIED

EFF_DATE CDATA #REQUIRED

SALARY CDATA #REQUIRED

a-dtype NMTOKENS 'EMP_NUM int

REVIEW_DATE date

EFF_DATE date

SALARY int'

a-fkey NMTOKENS 'EMP_NUM EMPLOYEE.NUM' >