Electronic Books

dmcinsights.com/ajax/.
??? The departments table has a
unique index on the department
column, ensuring that each
department is listed only once.
??? There is a one-to-many relationship
between the two tables.
Each employee can be in only
one department but each department
can have many employees.
This relationship is represented
by the department_id column,
which is in both tables.
??? You can create tables in php-
MyAdmin using either of the
SQL text areas as shown in
the examples or by using the
create table prompt. To use the
prompt, provide phpMyAdmin
with the name of the table and
the number of fi elds, and it will
create a form where you can
enter all of the column defi nitions.
populate the tables p. 7
??? The data being inserted isn??™t
important, so long as you populate
the tables with some information.
You can make up your
own records or download the
SQL commands from the book??™s
corresponding Web site at www.
dmcinsights.com/ajax/.
??? The department_id value for
each employee must correspond
to an actual department_id
from the departments table.
extra bits (cont.


Pages:
7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31