Tom Kelliher, CS 318
Due Feb. 13, 2002
Do the following:
BrotherInLaw
relation should
be defined as either an SQL query or predicate logic statement using the
other relations.
JOBS
, that will hold
information about a collection of jobs. For each job, the table should
hold the company, title, description, wage, experience level, job starting
date, and tuple delete date. Pick the most appropriate type for each
field. You may add additional columns to the table if you like. Write the
CREATE TABLE
statement used to create this table.
JOBS
table. Pick realistic
values for each field, and include at least two jobs with a delete date
of Feb. 1, 2002. Write the INSERT
statements used to populate
the table.
psql
to
perform these SQL operations. See the man page for script
for
instructions on creating a session log.