SQL Database Creation and Data Manipulation Quiz

The purpose of the 'CONSTRAINT DEPTPK PRIMARY KEY (DEPTID)' is to define the DEPTID column as the primary key of the DEPARTMENT1 table, ensuring that each DEPTID value is unique and not null.

The 'CONSTRAINT CHECKAGE CHECK (AGE BETWEEN 20 AND 60)' ensures that the AGE column in the EMPLOYEE table only allows values between 20 and 60, restricting the entry of invalid age values.

The 'CONSTRAINT PK_EMPLOYEE PRIMARY KEY (EMPID)' sets the EMPID column as the primary key of the EMPLOYEE table, ensuring that each EMPID value is unique and not null.

<p>The 'CONSTRAINT FK_EMPLOYEE FOREIGN KEY(DEPTID) REFERENCES DEPARTMENT1(DEPTID)' establishes the DEPTID column in the EMPLOYEE table as a foreign key referencing the DEPTID column in the DEPARTMENT1 table, enforcing referential integrity between the two tables.</p> Signup and view all the answers

<p>The 'HIREDATE DATE' column in the EMPLOYEE table is used to store the date when an employee was hired, providing a record of the employee's start date within the company.</p> Signup and view all the answers

<p>DEPTID INT, DNAME VARCHAR(20), LOC VARCHAR(10), MGRID VARCHAR(20)</p> Signup and view all the answers

<p>E101, ANAND, MANAGER, 2018-07-14, 40, 34000, 13</p> Signup and view all the answers

<p>2016-08-22</p> Signup and view all the answers

<p>RESEARCH, SALES</p> Signup and view all the answers

<p>DEPTPK PRIMARY KEY (DEPTID)</p> Signup and view all the answers