<footnote>
<para>
<ulink
- url="http://www.arsdigita.com/books/sql/data-modeling.html">
+ url="http://philip.greenspun.com/sql/data-modeling.html">
<citetitle>Philip Greenspun's "SQL For Web Nerds" - Data
Modeling</citetitle>
</ulink>
<listitem>
<para>
- <symbol>:column-</symbol> - A string which will be used as the
+ <symbol>:db-type</symbol> - A string which will be used as the
type specifier for this slots column definition in the database.
</para></listitem>
<para>
In an &sql; only application, the <symbol>EMPLOYEE</symbol> and
<symbol>COMPANY</symbol> tables can be queried to determine things
-like, "Who is Vladamir's manager?", "What company does Josef work
+like, "Who is Vladimir's manager?", "What company does Josef work
for?", and "What employees work for Widgets Inc.". This is done by
joining tables with an &sql; query.
</para>
</programlisting>
<para>
-Who is Vladamir's manager?
+Who is Vladimir's manager?
</para>
<programlisting>
SELECT managerid FROM employee
- WHERE employee.first_name = "Vladamir"
+ WHERE employee.first_name = "Vladimir"
AND employee.last_name = "Lenin"
</programlisting>
(defvar employee1 (make-instance 'employee
:emplid 1
- :first-name "Vladamir"
+ :first-name "Vladimir"
:last-name "Lenin"
:email "lenin@soviet.org"
:companyid 1))