A college consists of number of employees working in different departments. In this context, create two tables’ employee and department. Employee consists of columns empno, empname, basic, hra, da, deductions, gross, net, date-of-birth. The calculation of hra,da are as per the rules of the college. Initially only empno, empname, basic have valid values. Other values are to be computed and updated later. Department contains deptno, deptname, and description columns. Deptno is the primary key in department table and referential integrity constraint exists between
employee and department tables. Perform the following operations on the database:

Question:

1. Create tables department and employee with required constraints.
2. Initially only the few columns (essential) are to be added. Add the remaining columns separately by using appropriate SQL command
3. Basic column should not be null
4. Add constraint that basic should not be less than 5000.

Answer rating: 100% (QA)

1 CREATE TABLE Employee empno int11 NOT NULL AUTOINCREMENT em... View the full answer