Tom Kelliher, CS 318
Due Feb. 13, 2002
Do the following:
BrotherInLawrelation 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 TABLEstatement used to create this table.
JOBStable. Pick realistic values for each field, and include at least two jobs with a delete date of Feb. 1, 2002. Write the
INSERTstatements used to populate the table.
psqlto perform these SQL operations. See the man page for
scriptfor instructions on creating a session log.