Write constraint definitions for the following constraints
1. Primary key in the DEPT table
2. Foreign key DeptId in the EMPLOYEE table
3. CHECK constraint for QualId in the EMPLOYEE table
4. NOT NULL constraint for the MajorDesc column in the MAJOR table
5. UNIQUE constraint for DeptName in the DEPT table
1. Primary key in the DEPT table
CONSTRAINT dept_deptid_pk PRIMARY KEY (DeptId)
2. Foreign key DeptId in the EMPLOYEE table
CONSTRAINT employee_deptid_fk FOREIGN KEY (DeptId)
REFERENCES dept (DeptId)
3. CHECK constraint for QualId in the EMPLOYEE table
CONSTRAINT employee_qualid_ck
CHECK ((QualId >= 1) AND (QualId <= 5))
4. NOT NULL constraint for the MajorDesc column in the MAJOR table
MajorDesc VARCHAR2 (25) NOT NULL
5. UNIQUE constraint for DeptName in the DEPT table
CONSTRAINT dept_deptname_uk UNIQUE (DeptName)
You might also like to view...
Individual variables, compiler assigned global variables, register addressing, and multiple operands addressed and accessed in one cycle are characteristics of __________ organizations.
Fill in the blank(s) with the appropriate word(s).
When is the base case value == anArray[mid] (where mid is the midpoint of the array) reached in a recursive binary search algorithm?
What will be an ideal response?