You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-commits@db.apache.org by ch...@apache.org on 2011/04/15 22:16:32 UTC
svn commit: r1092801 - in /db/derby/code/branches/10.8: ./ java/demo/
java/demo/nserverdemo/ java/demo/simple/ java/demo/simplemobile/
java/demo/toursdb/ java/demo/workingwithderby/
Author: chaase3
Date: Fri Apr 15 20:16:32 2011
New Revision: 1092801
URL: http://svn.apache.org/viewvc?rev=1092801&view=rev
Log:
DERBY-5187 More accessibility fixes needed for demo pages
Merged DERBY-5187.diff to 10.8 code branch from trunk revision 1092795.
Modified:
db/derby/code/branches/10.8/ (props changed)
db/derby/code/branches/10.8/java/demo/csfull.css
db/derby/code/branches/10.8/java/demo/demo.html
db/derby/code/branches/10.8/java/demo/navbar.html
db/derby/code/branches/10.8/java/demo/nserverdemo/simpleserversample.html
db/derby/code/branches/10.8/java/demo/simple/example.html
db/derby/code/branches/10.8/java/demo/simplemobile/readme.html
db/derby/code/branches/10.8/java/demo/toursdb/toursdb_readme.html
db/derby/code/branches/10.8/java/demo/workingwithderby/readme.html
Propchange: db/derby/code/branches/10.8/
------------------------------------------------------------------------------
--- svn:mergeinfo (original)
+++ svn:mergeinfo Fri Apr 15 20:16:32 2011
@@ -1,2 +1,2 @@
/db/derby/code/branches/10.7:1061570,1061578,1082235
-/db/derby/code/trunk:1063809,1088633,1091000,1091221,1091285,1092067
+/db/derby/code/trunk:1063809,1088633,1091000,1091221,1091285,1092067,1092795
Modified: db/derby/code/branches/10.8/java/demo/csfull.css
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/demo/csfull.css?rev=1092801&r1=1092800&r2=1092801&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/demo/csfull.css (original)
+++ db/derby/code/branches/10.8/java/demo/csfull.css Fri Apr 15 20:16:32 2011
@@ -713,6 +713,12 @@ TD.heading {
color: #e7efff;
}
+TH.heading {
+ font-weight : bold;
+ background-color : #6699cc;
+ color: #e7efff;
+}
+
UL {
background-color : transparent;
}
Modified: db/derby/code/branches/10.8/java/demo/demo.html
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/demo/demo.html?rev=1092801&r1=1092800&r2=1092801&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/demo/demo.html (original)
+++ db/derby/code/branches/10.8/java/demo/demo.html Fri Apr 15 20:16:32 2011
@@ -15,7 +15,7 @@
limitations under the License.
-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
-<HTML>
+<HTML lang="en">
<HEAD><META http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<TITLE>Example Programs</TITLE>
<link rel="stylesheet" type="text/css" href="csfull.css" title="sample">
Modified: db/derby/code/branches/10.8/java/demo/navbar.html
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/demo/navbar.html?rev=1092801&r1=1092800&r2=1092801&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/demo/navbar.html (original)
+++ db/derby/code/branches/10.8/java/demo/navbar.html Fri Apr 15 20:16:32 2011
@@ -15,7 +15,7 @@
limitations under the License.
-->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
-<HTML>
+<HTML lang="en">
<HEAD>
<META http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<TITLE>Example Programs</TITLE>
Modified: db/derby/code/branches/10.8/java/demo/nserverdemo/simpleserversample.html
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/demo/nserverdemo/simpleserversample.html?rev=1092801&r1=1092800&r2=1092801&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/demo/nserverdemo/simpleserversample.html (original)
+++ db/derby/code/branches/10.8/java/demo/nserverdemo/simpleserversample.html Fri Apr 15 20:16:32 2011
@@ -68,7 +68,7 @@ from another JVM.</p>
Network Server before exiting the program.</li>
</ul>
-<p>The following files should be installed in the <font style=italic>%DERBY_INSTALL%</font><tt><span>\demo\programs\nserverdemo\</span></tt> directory in
+<p>The following files should be installed in the <tt><i>DERBY_INSTALL</i>\demo\programs\nserverdemo\</span></tt> directory in
order to run this sample program:</p>
<ul>
@@ -87,8 +87,8 @@ order to run this sample program:</p>
<p>To run this simple Derby Network Server sample program:</p>
<ol>
- <li>Open a command prompt and change directories to the <span class=italic>%DERBY_INSTALL%</span>\demo\programs\nserverdemo
- directory, where <span class=italic>%DERBY_INSTALL%</span> is the directory
+ <li>Open a command prompt and change directories to the <tt><i>DERBY_INSTALL</i>\demo\programs\nserverdemo\</tt>
+ directory, where <tt><i>DERBY_INSTALL</i></tt> is the directory
where you installed Derby.</li>
<li>Set the CLASSPATH to include the following jar files in order to run this
program.</li>
@@ -103,7 +103,7 @@ order to run this sample program:</p>
<p>This command will show the Derby jar files that are in the CLASSPATH. </p></li>
-<li>Once you have set up your environment correctly, execute the application from the <br><span class=italic>%DERBY_INSTALL%</span>\demo\programs\nserverdemo directory:
+<li>Once you have set up your environment correctly, execute the application from the <tt><i>DERBY_INSTALL</i>\demo\programs\nserverdemo</tt> directory:
<pre>java SimpleNetworkServerSample</pre>
</li></ol>
@@ -152,7 +152,7 @@ This log file contains Derby progress an
<li>closes the connections and then exits the program.</li>
</ul>
-<p>The following files should be installed in the <span class=italic>%DERBY_INSTALL%</span><tt>\demo\programs\nserverdemo\</tt> directory in order to run this sample program:</p>
+<p>The following files should be installed in the <tt><i>DERBY_INSTALL</i>\demo\programs\nserverdemo\</tt> directory in order to run this sample program:</p>
<ul>
<li>Source file: <br><tt>SimpleNetworkClientSample.java</tt></li>
<li>Compiled class file: <br><tt>SimpleNetworkClientSample.class</tt></li>
@@ -163,21 +163,19 @@ This log file contains Derby progress an
<p>To connect to the Network Server that has been started as part of the SimpleNetworkServerSample program:</p>
<ol>
- <li>Open a command prompt and change directories to the <span class=italic>%DERBY_INSTALL%</span><tt>\demo\programs\nserverdemo</tt> directory, where <span class=italic>%DERBY_INSTALL%</span> is the directory where you installed Derby.</li>
+ <li>Open a command prompt and change directories to the <tt><i>DERBY_INSTALL</i>\demo\programs\nserverdemo</tt> directory, where <tt><i>DERBY_INSTALL</i></tt> is the directory where you installed Derby.</li>
<li>Clients of Derby Network Server only need the following jar files in the CLASSPATH in order to connect to the Network Server.<span> </span>Set the CLASSPATH to include the following jar files:
<ul>
<li>the current directory (".")</li>
-<li><tt>derbyclient.jar</tt><br>This jar file must be in your CLASSPATH to use t
-he Derby Client Network JDBC Driver.</li>
+<li><tt>derbyclient.jar</tt><br>This jar file must be in your CLASSPATH to use
+the Derby Client Network JDBC Driver.</li>
</ul></li>
<li>Once you have set up your environment correctly, execute the
-application from the <br><span class=italic>%DERBY_INSTALL%</span><tt>\demo\programs\nserverdemo\</tt> directory:
-<pre><tt>java SimpleNetworkClientSample [driverType]</tt></pre>
+application from the <tt><i>DERBY_INSTALL</i>\demo\programs\nserverdemo\</tt> directory:
+<pre><tt>java SimpleNetworkClientSample [<i>driverType</i>]</tt></pre>
+<p>where the possible values for <i>driverType</i> are:</p>
<ul>
-<li>Where the possible values for driverType are:
-<ul>
-<li>derbyClient (default)
-</ul>
+<li>derbyClient (default)</li>
</ul>
</li>
</ol>
Modified: db/derby/code/branches/10.8/java/demo/simple/example.html
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/demo/simple/example.html?rev=1092801&r1=1092800&r2=1092801&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/demo/simple/example.html (original)
+++ db/derby/code/branches/10.8/java/demo/simple/example.html Fri Apr 15 20:16:32 2011
@@ -87,26 +87,27 @@ operates.
path separators and environment variable references to the Windows-specific
notation, for example:</em>
</p>
-<table class="simple">
+<table summary="This table provides UNIX and Windows examples of file and
+path separators and environment variable references." class="simple">
<tr>
- <td class="heading">Element</td>
- <td class="heading">Example, UNIX</td>
- <td class="heading">Example, Windows</td>
+ <th class="heading" id="c1">Element</td>
+ <th class="heading" id="c2">Example, UNIX</td>
+ <th class="heading" id="c3">Example, Windows</td>
</tr>
<tr>
- <td class="listItem">File separator</td>
- <td class="listItem"><em class="fileName">/home/path/file</em></td>
- <td class="listItem"><em class="fileName">c:\path\file</em></td>
+ <td class="listItem" headers="c1">File separator</td>
+ <td class="listItem" headers="c2"><em class="fileName">/home/path/file</em></td>
+ <td class="listItem" headers="c3"><em class="fileName">c:\path\file</em></td>
</tr>
<tr>
- <td class="listItem">(CLASS)PATH separator</td>
- <td class="listItem"><var class="envVar">derby.jar:derbytools.jar</var></td>
- <td class="listItem"><var class="envVar">derby.jar;derbytools.jar</var></td>
+ <td class="listItem" headers="c1">(CLASS)PATH separator</td>
+ <td class="listItem" headers="c2"><var class="envVar">derby.jar:derbytools.jar</var></td>
+ <td class="listItem" headers="c3"><var class="envVar">derby.jar;derbytools.jar</var></td>
</tr>
<tr>
- <td class="listItem">Environment Variable reference</td>
- <td class="listItem"><var class="envVar">$DERBY_HOME</var></td>
- <td class="listItem"><var class="envVar">%DERBY_HOME%</var></td>
+ <td class="listItem" headers="c1">Environment Variable reference</td>
+ <td class="listItem" headers="c2"><var class="envVar">$DERBY_HOME</var></td>
+ <td class="listItem" headers="c3"><var class="envVar">%DERBY_HOME%</var></td>
</tr>
</table>
<p>
Modified: db/derby/code/branches/10.8/java/demo/simplemobile/readme.html
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/demo/simplemobile/readme.html?rev=1092801&r1=1092800&r2=1092801&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/demo/simplemobile/readme.html (original)
+++ db/derby/code/branches/10.8/java/demo/simplemobile/readme.html Fri Apr 15 20:16:32 2011
@@ -218,19 +218,19 @@
<!-- ############### RESULTS ############### -->
<h2 class="Heading2"><a id="results" name="results">Results</a></h2>
<h3 class="heading4">Console output:</h3>
- <blockquote class="Output">
- SimpleMobileApp started<br>
- Connected to and created database simpleMobileDB<br>
- Created table streetaddr<br>
- Inserted 1956 Webster<br>
- Inserted 1910 Union<br>
- Updated 1956 Webster to 180 Grand<br>
- Updated 180 Grand to 300 Lakeshore<br>
- Verified the rows<br>
- Dropped table streetaddr<br>
- simpleMobileDB shut down successfully<br>
- SimpleMobileApp finished<br>
- </blockquote>
+ <pre class="Output">
+ SimpleMobileApp started
+ Connected to and created database simpleMobileDB
+ Created table streetaddr
+ Inserted 1956 Webster
+ Inserted 1910 Union
+ Updated 1956 Webster to 180 Grand
+ Updated 180 Grand to 300 Lakeshore
+ Verified the rows
+ Dropped table streetaddr
+ simpleMobileDB shut down successfully
+ SimpleMobileApp finished
+ </pre>
<p class="Body">
If any of the <a href="#requirements">requirements</a> are not fulfilled, the application
may fail with an error message. If you are unable to resolve this error, ask for
Modified: db/derby/code/branches/10.8/java/demo/toursdb/toursdb_readme.html
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/demo/toursdb/toursdb_readme.html?rev=1092801&r1=1092800&r2=1092801&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/demo/toursdb/toursdb_readme.html (original)
+++ db/derby/code/branches/10.8/java/demo/toursdb/toursdb_readme.html Fri Apr 15 20:16:32 2011
@@ -37,7 +37,7 @@
<H2><FONT SIZE="5">3. The toursdb schema</FONT></H2>
<P>The toursdb schema is the default schema, 'APP'.
<P>The toursdb tables are:
-<BR>(Note: in the following table no description is given where the columnname is deemed to be explanation enough.) <BR CLEAR="LEFT">
+<BR>(Note: in the following tables no description is given where the columnname is deemed to be explanation enough.) <BR CLEAR="LEFT">
<A HREF="#AIRLINES">AIRLINES</A> <BR CLEAR="LEFT">
<A HREF="#COUNTRIES">COUNTRIES</A> <BR CLEAR="LEFT">
<A HREF="#CITIES">CITIES</A> <BR CLEAR="LEFT">
@@ -45,537 +45,425 @@
<A HREF="#FLIGHTAVAILABILITY">FLIGHTAVAILABILITY</A> <BR CLEAR="LEFT">
<A HREF="#MAPS">MAPS</A> <BR CLEAR="LEFT">
<A HREF="#FLIGHTS_HISTORY">FLIGHTS_HISTORY</A>
-<P>Constraints and Indices are listed underneath the respective tables
+<P>Constraints and Indices are listed underneath the respective tables.
<P><A HREF="#TRIGGERS">TRIGGERS</A>
-<P>
+<P><A NAME="AIRLINES"></A>The AIRLINES table provides information about airline
+companies.</p>
<TABLE BORDER="1" BORDERCOLOR="#000000" CELLSPACING="0" CELLPADDING="4" WIDTH="100%">
+<caption>AIRLINES table</caption>
<TR>
- <TD WIDTH="19%" ALIGN="LEFT" VALIGN="TOP">TableName </TD>
- <TD WIDTH="30%" ALIGN="LEFT" VALIGN="TOP">ColumnName </TD>
- <TD WIDTH="22%" ALIGN="LEFT" VALIGN="TOP">DataType </TD>
- <TD WIDTH="6%" ALIGN="LEFT" VALIGN="TOP">other </TD>
- <TD WIDTH="19%" ALIGN="LEFT" VALIGN="TOP">Description </TD></TR>
+ <TH id="c11" WIDTH="33%" ALIGN="LEFT" VALIGN="TOP">ColumnName </TD>
+ <TH id="c21" WIDTH="33%" ALIGN="LEFT" VALIGN="TOP">DataType </TD>
+ <TH id="c31" WIDTH="34%" ALIGN="LEFT" VALIGN="TOP">Description </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="TOP"><A NAME="AIRLINES"></A>AIRLINES </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">Information about Airline companies </TD></TR>
+ <TD headers="c11" ALIGN="LEFT" VALIGN="TOP">AIRLINE </TD>
+ <TD headers="c21" ALIGN="LEFT" VALIGN="TOP">CHAR(2) </TD>
+ <TD headers="c31" ALIGN="LEFT" VALIGN="TOP">Airline company code
+ <p>PK, not null</p></TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">AIRLINE </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">CHAR(2) </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">PK, not null </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">Airline company code </TD></TR>
+ <TD headers="c11" ALIGN="LEFT" VALIGN="TOP">AIRLINE_FULL </TD>
+ <TD headers="c21" ALIGN="LEFT" VALIGN="TOP">VARCHAR(24) </TD>
+ <TD headers="c31" ALIGN="LEFT" VALIGN="TOP">Full name of Airline company </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">AIRLINE_FULL </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(24) </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">Full name of Airline company </TD></TR>
+ <TD headers="c11" ALIGN="LEFT" VALIGN="TOP">BASIC_RATE </TD>
+ <TD headers="c21" ALIGN="LEFT" VALIGN="TOP">DOUBLE_PRECISION </TD>
+ <TD headers="c31" ALIGN="LEFT" VALIGN="TOP">Basic rate for flying with this airline </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">BASIC_RATE </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">DOUBLE_PRECISION </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">Basic rate for flying with this airline </TD></TR>
+ <TD headers="c11" ALIGN="LEFT" VALIGN="TOP">DISTANCE_DISCOUNT </TD>
+ <TD headers="c21" ALIGN="LEFT" VALIGN="TOP">DOUBLE PRECISION </TD>
+ <TD headers="c31" ALIGN="LEFT" VALIGN="TOP">Discount for larger distances </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="TOP"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">DISTANCE_DISCOUNT </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">DOUBLE PRECISION </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">Discount for larger distances </TD></TR>
+ <TD headers="c11" ALIGN="LEFT" VALIGN="TOP">BUSINESS_LEVEL_FACTOR </TD>
+ <TD headers="c21" ALIGN="LEFT" VALIGN="TOP">DOUBLE PRECISION </TD>
+ <TD headers="c31" ALIGN="LEFT" VALIGN="TOP">Percentage addition for business class cost</TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="TOP"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">BUSINESS_LEVEL_FACTOR </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">DOUBLE PRECISION </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP"> </TD></TR>
+ <TD headers="c11" ALIGN="LEFT" VALIGN="TOP">FIRSTCLASS_LEVEL_FACTOR </TD>
+ <TD headers="c21" ALIGN="LEFT" VALIGN="TOP">DOUBLE PRECISION </TD>
+ <TD headers="c31" ALIGN="LEFT" VALIGN="TOP">Percentage addition for first class cost </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="TOP"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">FIRSTCLASS_LEVEL_FACTOR </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">DOUBLE PRECISION </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">Percentage addition for first class cost </TD></TR>
+ <TD headers="c11" ALIGN="LEFT" VALIGN="TOP">ECONOMY_SEATS </TD>
+ <TD headers="c21" ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
+ <TD headers="c31" ALIGN="LEFT" VALIGN="TOP">No. of economy seats </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="TOP"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">ECONOMY_SEATS </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">No. of economy seats </TD></TR>
+ <TD headers="c11" ALIGN="LEFT" VALIGN="TOP">BUSINESS_SEATS </TD>
+ <TD headers="c21" ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
+ <TD headers="c31" ALIGN="LEFT" VALIGN="TOP">No. of business seats </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="TOP"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">BUSINESS_SEATS </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">No. of business seats </TD></TR>
-
- <TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">FIRSTCLASS_SEATS </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">No. of first class seats </TD></TR>
+ <TD headers="c11" ALIGN="LEFT" VALIGN="TOP">FIRSTCLASS_SEATS </TD>
+ <TD headers="c21" ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
+ <TD headers="c31" ALIGN="LEFT" VALIGN="TOP">No. of first class seats </TD></TR>
</TABLE>
<P>CONSTRAINTS: <BR CLEAR="LEFT">
-<UL>constraint AIRLINES_PK AIRLINE Primary Key </UL>
+<pre> constraint AIRLINES_PK AIRLINE Primary Key</pre>
-<P>
+<P><A NAME="COUNTRIES"></A>The COUNTRIES table provides information about the
+countries served by the airlines.</p>
<TABLE BORDER="1" BORDERCOLOR="#000000" CELLSPACING="0" CELLPADDING="4" WIDTH="100%">
+<caption>COUNTRIES table</caption>
+ <TR>
+ <TH id="c12" WIDTH="33%" ALIGN="LEFT" VALIGN="TOP">ColumnName </TD>
+ <TH id="c22" WIDTH="33%" ALIGN="LEFT" VALIGN="TOP">DataType </TD>
+ <TH id="c32" WIDTH="34%" ALIGN="LEFT" VALIGN="TOP">Description </TD></TR>
+
+ <TR>
+ <TD headers="c12" ALIGN="LEFT" VALIGN="TOP">COUNTRY </TD>
+ <TD headers="c22" ALIGN="LEFT" VALIGN="TOP">VARCHAR(26) </TD>
+ <TD headers="c32" ALIGN="LEFT" VALIGN="TOP">Country name in English
+ <p>Not null</p> </TD></TR>
+
<TR>
- <TD WIDTH="19%" ALIGN="LEFT" VALIGN="TOP"><A NAME="COUNTRIES"></A>COUNTRIES </TD>
- <TD WIDTH="31%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="22%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="6%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="19%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
-
- <TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">COUNTRY </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(26) </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">not null </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">Country name in English </TD></TR>
-
- <TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">COUNTRY_ISO_CODE </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">CHAR(2) </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">PK, not null </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">Country code </TD></TR>
-
- <TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">REGION </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(26) </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">Region </TD></TR>
+ <TD headers="c12" ALIGN="LEFT" VALIGN="TOP">COUNTRY_ISO_CODE </TD>
+ <TD headers="c22" ALIGN="LEFT" VALIGN="TOP">CHAR(2) </TD>
+ <TD headers="c32" ALIGN="LEFT" VALIGN="TOP">Country code
+ <p>PK, not null</p> </TD></TR>
+
+ <TR>
+ <TD headers="c12" ALIGN="LEFT" VALIGN="TOP">REGION </TD>
+ <TD headers="c22" ALIGN="LEFT" VALIGN="TOP">VARCHAR(26) </TD>
+ <TD headers="c32" ALIGN="LEFT" VALIGN="TOP">Region </TD></TR>
</TABLE>
<P>CONSTRAINTS: <BR CLEAR="LEFT">
-<UL>constraint COUNTRIES_PK COUNTRY_ISO_CODE Primary Key <BR CLEAR="LEFT">
-constraint COUNTRIES_UNQ_NM Unique Country <BR CLEAR="LEFT">
-constraint COUNTRIES_UC Check country_ISO_code = upper(country_ISO_code) </UL>
+<PRE> constraint COUNTRIES_PK COUNTRY_ISO_CODE Primary Key
+ constraint COUNTRIES_UNQ_NM Unique Country
+ constraint COUNTRIES_UC Check country_ISO_code = upper(country_ISO_code)
+</PRE>
-<P>
+<P><A NAME="CITIES"></A>The CITIES table provides information about the cities
+served by the airlines.</p>
<TABLE BORDER="1" BORDERCOLOR="#000000" CELLSPACING="0" CELLPADDING="4" WIDTH="100%">
+<caption>CITIES table</caption>
<TR>
- <TD WIDTH="20%" ALIGN="LEFT" VALIGN="TOP"><A NAME="CITIES"></A>CITIES </TD>
- <TD WIDTH="32%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="23%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="6%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="16%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TH id="c13" WIDTH="33%" ALIGN="LEFT" VALIGN="TOP">ColumnName </TD>
+ <TH id="c23" WIDTH="33%" ALIGN="LEFT" VALIGN="TOP">DataType </TD>
+ <TH id="c33" WIDTH="34%" ALIGN="LEFT" VALIGN="TOP">Description </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">CITY_ID </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">PK, not null </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TD headers="c13" ALIGN="LEFT" VALIGN="TOP">CITY_ID </TD>
+ <TD headers="c23" ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
+ <TD headers="c33" ALIGN="LEFT" VALIGN="MIDDLE">PK, not null </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">CITY_NAME </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(24) </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">not null </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TD headers="c13" ALIGN="LEFT" VALIGN="TOP">CITY_NAME </TD>
+ <TD headers="c23" ALIGN="LEFT" VALIGN="TOP">VARCHAR(24) </TD>
+ <TD headers="c33" ALIGN="LEFT" VALIGN="MIDDLE">Not null </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">COUNTRY </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(26) </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">not null </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TD headers="c13" ALIGN="LEFT" VALIGN="TOP">COUNTRY </TD>
+ <TD headers="c23" ALIGN="LEFT" VALIGN="TOP">VARCHAR(26) </TD>
+ <TD headers="c33" ALIGN="LEFT" VALIGN="MIDDLE">Not null </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">AIRPORT </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(3) </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE">airport code </TD></TR>
+ <TD headers="c13" ALIGN="LEFT" VALIGN="TOP">AIRPORT </TD>
+ <TD headers="c23" ALIGN="LEFT" VALIGN="TOP">VARCHAR(3) </TD>
+ <TD headers="c33" ALIGN="LEFT" VALIGN="MIDDLE">Airport code </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">LANGUAGE </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(16) </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TD headers="c13" ALIGN="LEFT" VALIGN="TOP">LANGUAGE </TD>
+ <TD headers="c23" ALIGN="LEFT" VALIGN="TOP">VARCHAR(16) </TD>
+ <TD headers="c33" ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">COUNTRY_ISO_CODE </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">CHAR(2) </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">FK </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TD headers="c13" ALIGN="LEFT" VALIGN="TOP">COUNTRY_ISO_CODE </TD>
+ <TD headers="c23" ALIGN="LEFT" VALIGN="TOP">CHAR(2) </TD>
+ <TD headers="c33" ALIGN="LEFT" VALIGN="MIDDLE">FK </TD></TR>
</TABLE>
<P>CONSTRAINTS: <BR CLEAR="LEFT">
-<UL>constraint CITIES_PK CITY_ID Primary Key <BR CLEAR="LEFT">
-constraint COUNTRIES_FK Foreign Key COUNTRY_ISO_CODE references <BR CLEAR="LEFT">
-</UL>
-
+<PRE> constraint CITIES_PK CITY_ID Primary Key
+ constraint COUNTRIES_FK Foreign Key COUNTRY_ISO_CODE references
+ COUNTRIES.COUNTRY_ISO_CODE
+</PRE>
-<UL><UL><UL>COUNTRIES.COUNTRY_ISO_CODE</UL></UL></UL>
-
-<P>
+<P><A NAME="FLIGHTS"></A>The FLIGHTS table provides information about airline
+flights.</p>
<TABLE BORDER="1" BORDERCOLOR="#000000" CELLSPACING="0" CELLPADDING="4" WIDTH="100%">
+<caption>FLIGHTS table</caption>
<TR>
- <TD WIDTH="19%" ALIGN="LEFT" VALIGN="TOP"><A NAME="FLIGHTS"></A>FLIGHTS </TD>
- <TD WIDTH="31%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="22%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="6%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="19%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TH id="c14" WIDTH="33%" ALIGN="LEFT" VALIGN="TOP">ColumnName </TD>
+ <TH id="c24" WIDTH="33%" ALIGN="LEFT" VALIGN="TOP">DataType </TD>
+ <TH id="c34" WIDTH="34%" ALIGN="LEFT" VALIGN="TOP">Description </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">FLIGHT_ID </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">CHAR(6) </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">PK, not null </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TD headers="c14" ALIGN="LEFT" VALIGN="TOP">FLIGHT_ID </TD>
+ <TD headers="c24" ALIGN="LEFT" VALIGN="TOP">CHAR(6) </TD>
+ <TD headers="c34" ALIGN="LEFT" VALIGN="MIDDLE">PK, not null </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">SEGMENT_NUMBER </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">PK, not null </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">number for segment of a flight </TD></TR>
+ <TD headers="c14" ALIGN="LEFT" VALIGN="TOP">SEGMENT_NUMBER </TD>
+ <TD headers="c24" ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
+ <TD headers="c34" ALIGN="LEFT" VALIGN="TOP">Number for segment of a flight
+ <p>PK, not null</p> </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">ORIG_AIRPORT </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">CHAR(3) </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">airport where flight originates </TD></TR>
+ <TD headers="c14" ALIGN="LEFT" VALIGN="TOP">ORIG_AIRPORT </TD>
+ <TD headers="c24" ALIGN="LEFT" VALIGN="TOP">CHAR(3) </TD>
+ <TD headers="c34" ALIGN="LEFT" VALIGN="TOP">Airport where flight originates </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">DEPART_TIME </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">TIME </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">scheduled departure time </TD></TR>
+ <TD headers="c14" ALIGN="LEFT" VALIGN="TOP">DEPART_TIME </TD>
+ <TD headers="c24" ALIGN="LEFT" VALIGN="TOP">TIME </TD>
+ <TD headers="c34" ALIGN="LEFT" VALIGN="TOP">Scheduled departure time </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">DEST_AIRPORT </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">CHAR(3) </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">destination airport </TD></TR>
+ <TD headers="c14" ALIGN="LEFT" VALIGN="TOP">DEST_AIRPORT </TD>
+ <TD headers="c24" ALIGN="LEFT" VALIGN="TOP">CHAR(3) </TD>
+ <TD headers="c34" ALIGN="LEFT" VALIGN="TOP">Destination airport </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">ARRIVE_TIME </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">TIME </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">scheduled arrival time </TD></TR>
+ <TD headers="c14" ALIGN="LEFT" VALIGN="TOP">ARRIVE_TIME </TD>
+ <TD headers="c24" ALIGN="LEFT" VALIGN="TOP">TIME </TD>
+ <TD headers="c34" ALIGN="LEFT" VALIGN="TOP">Scheduled arrival time </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">MEAL </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">CHAR(1) </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">indicator for type of meals available<BR CLEAR="LEFT">
+ <TD headers="c14" ALIGN="LEFT" VALIGN="TOP">MEAL </TD>
+ <TD headers="c24" ALIGN="LEFT" VALIGN="TOP">CHAR(1) </TD>
+ <TD headers="c34" ALIGN="LEFT" VALIGN="TOP">Indicator for type of meals available:<BR CLEAR="LEFT">
B - Breakfast<BR CLEAR="LEFT">
L - Lunch<BR CLEAR="LEFT">
D - Dinner<BR CLEAR="LEFT">
S - Snack </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">FLYING_TIME </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">DOUBLE PRECISION </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">scheduled duration of flight </TD></TR>
-
- <TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">MILES </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">length of flight </TD></TR>
-
- <TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">AIRCRAFT </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(6) </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">type of aircraft </TD></TR>
+ <TD headers="c14" ALIGN="LEFT" VALIGN="TOP">FLYING_TIME </TD>
+ <TD headers="c24" ALIGN="LEFT" VALIGN="TOP">DOUBLE PRECISION </TD>
+ <TD headers="c34" ALIGN="LEFT" VALIGN="TOP">Scheduled duration of flight </TD></TR>
+
+ <TR>
+ <TD headers="c14" ALIGN="LEFT" VALIGN="TOP">MILES </TD>
+ <TD headers="c24" ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
+ <TD headers="c34" ALIGN="LEFT" VALIGN="TOP">Length of flight </TD></TR>
+
+ <TR>
+ <TD headers="c14" ALIGN="LEFT" VALIGN="TOP">AIRCRAFT </TD>
+ <TD headers="c24" ALIGN="LEFT" VALIGN="TOP">VARCHAR(6) </TD>
+ <TD headers="c34" ALIGN="LEFT" VALIGN="TOP">Type of aircraft </TD></TR>
</TABLE>
<P>CONSTRAINTS: <BR CLEAR="LEFT">
-<UL>constraint FLIGHTS_PK FLIGHT_ID,SEGMENT_NUMBER Primary Key <BR CLEAR="LEFT">
-constraint MEAL_COUNSTRAINT Check meal IN ('B', 'L', 'D', 'S') </UL>
+<PRE> constraint FLIGHTS_PK FLIGHT_ID,SEGMENT_NUMBER Primary Key
+ constraint MEAL_CONSTRAINT Check meal IN ('B', 'L', 'D', 'S') </PRE>
<P>INDICES: <BR CLEAR="LEFT">
-<UL>index DESTINDEX on FLIGHTS (DEST_AIRPORT) <BR CLEAR="LEFT">
-index ORIGINDEX on FLIGHTS (ORIG_AIRPORT) </UL>
+<PRE> index DESTINDEX on FLIGHTS (DEST_AIRPORT)
+ index ORIGINDEX on FLIGHTS (ORIG_AIRPORT) </PRE>
-<P>
+<P><A NAME="FLIGHTAVAILABILITY"></A>The FLIGHTAVAILABILITY table provides
+information about the availability of flights.</p>
<TABLE BORDER="1" BORDERCOLOR="#000000" CELLSPACING="0" CELLPADDING="4" WIDTH="100%">
+<caption>FLIGHTAVAILABILITY table</caption>
<TR>
- <TD WIDTH="20%" ALIGN="LEFT" VALIGN="TOP"><A NAME="FLIGHTAVAILABILITY"></A>FLIGHTAVAILABILITY </TD>
- <TD WIDTH="31%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="23%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="6%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="18%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TH id="c15" WIDTH="33%" ALIGN="LEFT" VALIGN="TOP">ColumnName </TD>
+ <TH id="c25" WIDTH="33%" ALIGN="LEFT" VALIGN="TOP">DataType </TD>
+ <TH id="c35" WIDTH="34%" ALIGN="LEFT" VALIGN="TOP">Description </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">FLIGHT_ID </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">CHAR(6) </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">PK, not null </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TD headers="c15" ALIGN="LEFT" VALIGN="TOP">FLIGHT_ID </TD>
+ <TD headers="c25" ALIGN="LEFT" VALIGN="TOP">CHAR(6) </TD>
+ <TD headers="c35" ALIGN="LEFT" VALIGN="MIDDLE">PK, not null </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">SEGMENT_NUMBER </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">PK, not null </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE">number for segment of a flight</TD></TR>
+ <TD headers="c15" ALIGN="LEFT" VALIGN="TOP">SEGMENT_NUMBER </TD>
+ <TD headers="c25" ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
+ <TD headers="c35" ALIGN="LEFT" VALIGN="MIDDLE">Number for segment of a flight
+ <p>PK, not null</p> </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">FLIGHT_DATE </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">DATE </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">PK, not null </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE">date on which the flight takes place </TD></TR>
+ <TD headers="c15" ALIGN="LEFT" VALIGN="TOP">FLIGHT_DATE </TD>
+ <TD headers="c25" ALIGN="LEFT" VALIGN="TOP">DATE </TD>
+ <TD headers="c35" ALIGN="LEFT" VALIGN="MIDDLE">Date on which the flight takes place
+ <p>PK, not null</p> </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">ECONOMY_SEATS_TAKEN </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">def. 0 </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TD headers="c15" ALIGN="LEFT" VALIGN="TOP">ECONOMY_SEATS_TAKEN </TD>
+ <TD headers="c25" ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
+ <TD headers="c35" ALIGN="LEFT" VALIGN="MIDDLE">Default is 0 </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">BUSINESS_SEATS_TAKEN </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">def. 0 </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TD headers="c15" ALIGN="LEFT" VALIGN="TOP">BUSINESS_SEATS_TAKEN </TD>
+ <TD headers="c25" ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
+ <TD headers="c35" ALIGN="LEFT" VALIGN="MIDDLE">Default is 0 </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">FIRSTCLASS_SEATS_TAKEN </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">def. 0 </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TD headers="c15" ALIGN="LEFT" VALIGN="TOP">FIRSTCLASS_SEATS_TAKEN </TD>
+ <TD headers="c25" ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
+ <TD headers="c35" ALIGN="LEFT" VALIGN="MIDDLE">Default is 0 </TD></TR>
</TABLE>
-<P>def. = default
<P>CONSTRAINTS: <BR CLEAR="LEFT">
-<UL>constraint FLIGHT_AVAILABILITY_PK FLIGHT_ID, SEGMENT_NUMBER, FLIGHT_DATE Primary Key <BR CLEAR="LEFT">
-constraint FLIGHTS_FK2 Foreign Key FLIGHT_ID,SEGMENT_NUMBER references </UL>
-
+<PRE> constraint FLIGHT_AVAILABILITY_PK FLIGHT_ID, SEGMENT_NUMBER, FLIGHT_DATE Primary Key
+ constraint FLIGHTS_FK2 Foreign Key FLIGHT_ID,SEGMENT_NUMBER references
+ FLIGHTS. FLIGHT_ID, SEGMENT_NUMBER </PRE>
-<UL><UL><UL>FLIGHTS. FLIGHT_ID, SEGMENT_NUMBER</UL></UL></UL>
-
-<P>
+<P><A NAME="MAPS"></A>The MAPS table provides information about flight maps.</p>
<TABLE BORDER="1" BORDERCOLOR="#000000" CELLSPACING="0" CELLPADDING="4" WIDTH="100%">
+<caption>MAPS table</caption>
<TR>
- <TD WIDTH="20%" ALIGN="LEFT" VALIGN="TOP"><A NAME="MAPS"></A>MAPS </TD>
- <TD WIDTH="31%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="23%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="6%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="18%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TH id="c16" WIDTH="33%" ALIGN="LEFT" VALIGN="TOP">ColumnName </TD>
+ <TH id="c26" WIDTH="33%" ALIGN="LEFT" VALIGN="TOP">DataType </TD>
+ <TH id="c36" WIDTH="34%" ALIGN="LEFT" VALIGN="TOP">Description </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">MAP_ID </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">not null, <P>gen. alw. as id. st. 1 incr. by 1 </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TD headers="c16" ALIGN="LEFT" VALIGN="TOP">MAP_ID </TD>
+ <TD headers="c26" ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
+ <TD headers="c36" ALIGN="LEFT" VALIGN="MIDDLE">Not null, generated always as identity (start with 1, increment by 1)</TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">MAP_NAME </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(24) </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">not null </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TD headers="c16" ALIGN="LEFT" VALIGN="TOP">MAP_NAME </TD>
+ <TD headers="c26" ALIGN="LEFT" VALIGN="TOP">VARCHAR(24) </TD>
+ <TD headers="c36" ALIGN="LEFT" VALIGN="MIDDLE">Not null </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">REGION </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(26) </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TD headers="c16" ALIGN="LEFT" VALIGN="TOP">REGION </TD>
+ <TD headers="c26" ALIGN="LEFT" VALIGN="TOP">VARCHAR(26) </TD>
+ <TD headers="c36" ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">AREA DECIMAL(8,4) </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">not null </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TD headers="c16" ALIGN="LEFT" VALIGN="TOP">AREA </TD>
+ <TD headers="c26" ALIGN="LEFT" VALIGN="MIDDLE">DECIMAL(8,4) </TD>
+ <TD headers="c36" ALIGN="LEFT" VALIGN="MIDDLE">Not null </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">PHOTO_FORMAT </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(26) </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">not null </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TD headers="c16" ALIGN="LEFT" VALIGN="TOP">PHOTO_FORMAT </TD>
+ <TD headers="c26" ALIGN="LEFT" VALIGN="TOP">VARCHAR(26) </TD>
+ <TD headers="c36" ALIGN="LEFT" VALIGN="MIDDLE">Not null </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">PICTURE </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">BLOB(102400) </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TD headers="c16" ALIGN="LEFT" VALIGN="TOP">PICTURE </TD>
+ <TD headers="c26" ALIGN="LEFT" VALIGN="TOP">BLOB(102400) </TD>
+ <TD headers="c36" ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
</TABLE>
-<P>gen alw. as id. st. 1 incr. by 1 = generated always as identity (start with 1, increment by 1)
<P>CONSTRAINTS: <BR CLEAR="LEFT">
-<UL>constraint Unique MAP_ID, MAP_NAME </UL>
+<PRE> constraint Unique MAP_ID, MAP_NAME </PRE>
-<P>
+<P><A NAME="FLIGHTS_HISTORY"></A>The FLIGHTS_HISTORY table provides information
+about archived flights.</p>
<TABLE BORDER="1" BORDERCOLOR="#000000" CELLSPACING="0" CELLPADDING="4" WIDTH="100%">
+<caption>FLIGHTS_HISTORY table</caption>
<TR>
- <TD WIDTH="20%" ALIGN="LEFT" VALIGN="TOP"><A NAME="FLIGHTS_HISTORY"></A>FLIGHTS_HISTORY </TD>
- <TD WIDTH="30%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="22%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="6%" ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD WIDTH="18%" ALIGN="LEFT" VALIGN="TOP">archived flights </TD></TR>
+ <TH id="c17" WIDTH="33%" ALIGN="LEFT" VALIGN="TOP">ColumnName </TD>
+ <TH id="c27" WIDTH="33%" ALIGN="LEFT" VALIGN="TOP">DataType </TD>
+ <TH id="c37" WIDTH="34%" ALIGN="LEFT" VALIGN="TOP">Description </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">FLIGHT_ID </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">CHAR(6) </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">not null </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD></TR>
+ <TD headers="c17" ALIGN="LEFT" VALIGN="TOP">FLIGHT_ID </TD>
+ <TD headers="c27" ALIGN="LEFT" VALIGN="TOP">CHAR(6) </TD>
+ <TD headers="c37" ALIGN="LEFT" VALIGN="MIDDLE">Not null </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">SEGMENT_NUMBER </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">not null </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">number for segment of a flight </TD></TR>
+ <TD headers="c17" ALIGN="LEFT" VALIGN="TOP">SEGMENT_NUMBER </TD>
+ <TD headers="c27" ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
+ <TD headers="c37" ALIGN="LEFT" VALIGN="TOP">Number for segment of a flight
+ <p>Not null</p> </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">ORIG_AIRPORT </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">CHAR(3) </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">airport where flight originates </TD></TR>
+ <TD headers="c17" ALIGN="LEFT" VALIGN="TOP">ORIG_AIRPORT </TD>
+ <TD headers="c27" ALIGN="LEFT" VALIGN="TOP">CHAR(3) </TD>
+ <TD headers="c37" ALIGN="LEFT" VALIGN="TOP">Airport where flight originates </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">DEPART_TIME </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">TIME </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">scheduled departure time </TD></TR>
+ <TD headers="c17" ALIGN="LEFT" VALIGN="TOP">DEPART_TIME </TD>
+ <TD headers="c27" ALIGN="LEFT" VALIGN="TOP">TIME </TD>
+ <TD headers="c37" ALIGN="LEFT" VALIGN="TOP">Scheduled departure time </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">DEST_AIRPORT </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">CHAR(3) </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">destination airport </TD></TR>
+ <TD headers="c17" ALIGN="LEFT" VALIGN="TOP">DEST_AIRPORT </TD>
+ <TD headers="c27" ALIGN="LEFT" VALIGN="TOP">CHAR(3) </TD>
+ <TD headers="c37" ALIGN="LEFT" VALIGN="TOP">Destination airport </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">ARRIVE_TIME </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">TIME </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">scheduled arrival time </TD></TR>
+ <TD headers="c17" ALIGN="LEFT" VALIGN="TOP">ARRIVE_TIME </TD>
+ <TD headers="c27" ALIGN="LEFT" VALIGN="TOP">TIME </TD>
+ <TD headers="c37" ALIGN="LEFT" VALIGN="TOP">Scheduled arrival time </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">MEAL </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">CHAR(1) </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">indicator for type of meals available<BR CLEAR="LEFT">
+ <TD headers="c17" ALIGN="LEFT" VALIGN="TOP">MEAL </TD>
+ <TD headers="c27" ALIGN="LEFT" VALIGN="TOP">CHAR(1) </TD>
+ <TD headers="c37" ALIGN="LEFT" VALIGN="TOP">Indicator for type of meals available:<BR CLEAR="LEFT">
B - Breakfast<BR CLEAR="LEFT">
L - Lunch<BR CLEAR="LEFT">
D - Dinner<BR CLEAR="LEFT">
S - Snack </TD></TR>
<TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">FLYING_TIME </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">DOUBLE PRECISION </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">scheduled duration of flight </TD></TR>
-
- <TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">MILES </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">length of flight </TD></TR>
-
- <TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">AIRCRAFT </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(6) </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">type of aircraft </TD></TR>
-
- <TR>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">STATUS </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">VARCHAR(20) </TD>
- <TD ALIGN="LEFT" VALIGN="MIDDLE"> </TD>
- <TD ALIGN="LEFT" VALIGN="TOP">code indicating which trigger created the record </TD></TR>
+ <TD headers="c17" ALIGN="LEFT" VALIGN="TOP">FLYING_TIME </TD>
+ <TD headers="c27" ALIGN="LEFT" VALIGN="TOP">DOUBLE PRECISION </TD>
+ <TD headers="c37" ALIGN="LEFT" VALIGN="TOP">Scheduled duration of flight </TD></TR>
-</TABLE>
+ <TR>
+ <TD headers="c17" ALIGN="LEFT" VALIGN="TOP">MILES </TD>
+ <TD headers="c27" ALIGN="LEFT" VALIGN="TOP">INTEGER </TD>
+ <TD headers="c37" ALIGN="LEFT" VALIGN="TOP">Length of flight </TD></TR>
-<P><A NAME="TRIGGERS"></A>TRIGGERS:
+ <TR>
+ <TD headers="c17" ALIGN="LEFT" VALIGN="TOP">AIRCRAFT </TD>
+ <TD headers="c27" ALIGN="LEFT" VALIGN="TOP">VARCHAR(6) </TD>
+ <TD headers="c37" ALIGN="LEFT" VALIGN="TOP">Type of aircraft </TD></TR>
+
+ <TR>
+ <TD headers="c17" ALIGN="LEFT" VALIGN="TOP">STATUS </TD>
+ <TD headers="c27" ALIGN="LEFT" VALIGN="TOP">VARCHAR(20) </TD>
+ <TD headers="c37" ALIGN="LEFT" VALIGN="TOP">Code indicating which trigger created the record </TD></TR>
+
+</TABLE>
-<UL>TRIG1 <BR CLEAR="LEFT">
-</UL>
+<P><A NAME="TRIGGERS"></A>TRIGGERS: </p>
+<PRE> TRIG1
-<UL><UL>after update on FLIGHTS <BR CLEAR="LEFT">
-referencing old as UPDATEDROW <BR CLEAR="LEFT">
-for each row <BR CLEAR="LEFT">
-insert into FLIGHTS_HISTORY values ( <BR CLEAR="LEFT">
-UPDATEDROW.FLIGHT_ID, <BR CLEAR="LEFT">
-UPDATEDROW.SEGMENT_NUMBER, <BR CLEAR="LEFT">
-UPDATEDROW.ORIG_AIRPORT, <BR CLEAR="LEFT">
-UPDATEDROW.DEPART_TIME, <BR CLEAR="LEFT">
-UPDATEDROW.DEST_AIRPORT, <BR CLEAR="LEFT">
-UPDATEDROW.ARRIVE_TIME, <BR CLEAR="LEFT">
-UPDATEDROW.MEAL, <BR CLEAR="LEFT">
-UPDATEDROW.FLYING_TIME, <BR CLEAR="LEFT">
-UPDATEDROW.MILES, <BR CLEAR="LEFT">
-UPDATEDROW.AIRCRAFT, <BR CLEAR="LEFT">
-'INSERTED FROM TRIG1'); </UL></UL>
-
-
-<UL>TRIG2 <BR CLEAR="LEFT">
-</UL>
-
-
-<UL><UL>after delete on FLIGHTS <BR CLEAR="LEFT">
-for each statement <BR CLEAR="LEFT">
-insert into FLIGHTS_HISTORY (STATUS) values ('INSERTED FROM TRIG2');
+ after update on FLIGHTS
+ referencing old as UPDATEDROW
+ for each row
+ insert into FLIGHTS_HISTORY values (
+ UPDATEDROW.FLIGHT_ID,
+ UPDATEDROW.SEGMENT_NUMBER,
+ UPDATEDROW.ORIG_AIRPORT,
+ UPDATEDROW.DEPART_TIME,
+ UPDATEDROW.DEST_AIRPORT,
+ UPDATEDROW.ARRIVE_TIME,
+ UPDATEDROW.MEAL,
+ UPDATEDROW.FLYING_TIME,
+ UPDATEDROW.MILES,
+ UPDATEDROW.AIRCRAFT,
+ 'INSERTED FROM TRIG1');
+
+ TRIG2
+
+ after delete on FLIGHTS
+ for each statement
+ insert into FLIGHTS_HISTORY (STATUS) values ('INSERTED FROM TRIG2');
+</PRE>
</BODY>
Modified: db/derby/code/branches/10.8/java/demo/workingwithderby/readme.html
URL: http://svn.apache.org/viewvc/db/derby/code/branches/10.8/java/demo/workingwithderby/readme.html?rev=1092801&r1=1092800&r2=1092801&view=diff
==============================================================================
--- db/derby/code/branches/10.8/java/demo/workingwithderby/readme.html (original)
+++ db/derby/code/branches/10.8/java/demo/workingwithderby/readme.html Fri Apr 15 20:16:32 2011
@@ -40,15 +40,14 @@
the edits described in the activity.</p></LI>
</UL>
<UL>
- <LI><A href="WwdUtils.java">WwdUtils.java</A>
-</UL>
-<BLOCKQUOTE>These are utility methods used by the Getting Started With Derby programs that
+ <LI><p class="BodyRelative"><A href="WwdUtils.java">WwdUtils.java</A></p>
+<P class="BodyRelative">These are utility methods used by the Getting Started With Derby programs that
are not described in the document. The processing performed by these methods
does not demonstrate basic JDBC processing and so is outside the scope
of an introductory document like Getting Started With Derby. These methods provide
environment validation and manage user input so the program is more robust.
The code is provided here for people interested in examining the processing.
-It contains three methods:<BR>
+It contains three methods:</P>
<OL>
<LI>getWishItem - Prompts for user input and returns the entered text, if any,
to the calling program. Handles I/O Exceptions and insists that some text
@@ -56,7 +55,8 @@ It contains three methods:<BR>
<LI>wwdChk4Table - Checks if the table needed by the program already exists
and is defined properly. Handles certain errors that could occur.
<LI>main - Allows standalone testing of the getWishItem method.
-</OL>
-</BLOCKQUOTE>
+</OL></LI>
+</UL>
+
</BODY>
</HTML>