How does the CHECK constraint shown below work? Which tables does it work on? CREATE TABLE DEPT_MGR ( Dname VARCHAR(15) NOT NULL, Mgr_ssn CHAR(9) NOT NULL, Mgr_start_date DATE NOT NULL,...

How does the CHECK constraint shown below work? Which tables does it work on?<br>CREATE TABLE DEPT_MGR (<br>Dname VARCHAR(15)<br>NOT NULL,<br>Mgr_ssn<br>CHAR(9)<br>NOT NULL,<br>Mgr_start_date DATE<br>NOT NULL,<br>Dept_create_date DATE<br>NOT NULL,<br>PRIMARY KEY (Dname),<br>FOREIGN KEY (Mgr_ssn) REFERENCES EMPLOYEE(Ssn)<br>CONSTRAINT CHK_DATE CHECK (Dept_create_date <= Mgr_start_date ));<br>

Extracted text: How does the CHECK constraint shown below work? Which tables does it work on? CREATE TABLE DEPT_MGR ( Dname VARCHAR(15) NOT NULL, Mgr_ssn CHAR(9) NOT NULL, Mgr_start_date DATE NOT NULL, Dept_create_date DATE NOT NULL, PRIMARY KEY (Dname), FOREIGN KEY (Mgr_ssn) REFERENCES EMPLOYEE(Ssn) CONSTRAINT CHK_DATE CHECK (Dept_create_date <= mgr_start_date="">

Jun 06, 2022

SOLUTION.PDF

How does the CHECK constraint shown below work? Which tables does it work on? CREATE TABLE DEPT_MGR ( Dname VARCHAR(15) NOT NULL, Mgr_ssn CHAR(9) NOT NULL, Mgr_start_date DATE NOT NULL,...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment