Enterprise Application Integration With XML and Java™

6.3. The Example

Let's use a simple example to work in the concrete. The following is an employee database with three tables. EMPLOYEE stores personal information and a summary of the term of the relationship. PERF_REVIEW stores performance reviews given to the employee. COMP_CHANGE stores changes to compensation resulting (usually but not always) from a performance review.

TABLE EMPLOYEE
      NUM  LONGINT  PRIMARY KEY
      FNAME  STRING 32
      LNAME  STRING 32
      HIRE_DATE  DATE  
      TERM_DATE  DATE  MAY BE NULL
  
TABLE PERF_REVIEW
      EMP_NUM  LONGINT  PRIMARY KEY  FOREIGN KEY
      REVIEW_DATE  DATE  PRIMARY KEY
      REVIEW  TEXT
      
TABLE COMP_CHANGE
      EMP_NUM  LONGINT  FOREIGN KEY
      REVIEW_DATE  DATE  MAY BE NULL
      EFF_DATE  DATE
      SALARY  INT

At its simplest, an XML document of information drawn from this ...