A college consists of number of employees working in different departments. In this context, create two tables
Fantastic news! We've Found the answer you've been seeking!
Question:
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:
- Create tables department and employee with required constraints.
- Initially only the few columns (essential) are to be added. Add the remaining columns separately by using appropriate SQL command
- Basic column should not be null
- Add constraint that basic should not be less than 5000.
Related Book For
Human Resource Management
ISBN: 978-0538453158
13th Edition
Authors: Robert L. Mathis, John H. Jackson
Posted Date: