title: CHECK constraint to restrict the registration date to dates after August 26, 2005
body: <p>Need some help with this:</p>
  
  <blockquote>
    <p>Create a table called TEMP_STUDENT with the following columns and
    constraints: a column STUD_ID for the student ID and is the primary
    key, a column FIRST_NAME for student first name, a column LAST_NAME
    for student last name, a column ZIP that is a foreign key to the ZIP
    column in the ZIPCODE table of the Student Database Schema, and a
    column REGISTRATION_DATE that is NOT NULL and has a CHECK constraint
    to restrict the registration date to dates after August 26, 2005.  ALL
    CONSTRAINTS MUST BE NAMED.  Both the first_name and last_name columns
    are required.</p>
  </blockquote>
  
  <p>I got this:</p>
  
  <pre><code>CREATE TABLE Temp_Student
  (STUD_ID NUMBER (8,0),
  FIRST_NAME VARCHAR2(25) NOT NULL,
  LAST_NAME VARCHAR2(25) NOT NULL,
  ZIP VARCHAR2(5),
  REGISTRATION_DATE DATE NOT NULL,
  CONSTRAINT STUD_ID_PK PRIMARY KEY(STUD_ID),
  CONSTRAINT ZIP_FK FOREIGN KEY (ZIP)
  REFERENCES ZIPCODE (ZIP),
  CONSTRAINT chk_REGISTRATION_DATE CHECK (REGISTRATION_DATE&gt; REGISTRATION_DATE 'TO DATE('26-AUGUST-2005'))
  );
  </code></pre>
  
  <p>Any help with the last constraint, it would be much appreciated i have no idea what im doing.</p>
  
  <p>keep getting this message:</p>
  
  <pre><code>CONSTRAINT chk_REGISTRATION_DATE CHECK (REGISTRATION_DATE&gt; REGISTRATION_DATE 'TO DATE('26-AUGUST-2005')')
                                                                               *
  ERROR at line 10: 
  ORA-00907: missing right parenthesis 
  </code></pre>