RDBMS LAB MANUAL Roll.No:1

The EMPLOYER_ZIP column should have a foreign key constraint that references the ZIP column of the ZIPCODE table. Update the EMPLOYER column, and alter the table once again to make the EMPLOYER column NOT NULL. Drop the TEMP_STUDENT table when you are done with the exercise. Solution: ALTER TABLE temp_student. ADD (employer VARCHAR2(20), ................
................

In order to avoid copyright disputes, this page is only a partial summary.