Instruction: Students should be allowed to choose appropriate DBMS software, install it, 
configure it and start working on it. Create sample tables, execute some queries, use SQLPLUS 
features, use PL/SQL features like cursors on sample database. Students should be permitted to 
practice appropriate User interface creation tool and Report generation tool.     

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)

Q1 CREATE TABLE Employee empno int11 NOT NULL AUTOINCREMENT e... View the full answer