About this document

SQL Tasks: Employee and Department Management by Abdullah is a document available to read on EtoBox.

The document outlines 6 tasks related to creating and manipulating tables in a database: 1. Create new EMPLOYEE and DEPART tables from existing EMP and DEPT tables, with a primary key-foreign key relationship between them. 2. Insert 2 records into EMPLOYEE table linking employees to departments. 3. Update the name and salary of one employee record. 4. Delete any records from EMPLOYEE where job is analyst. 5. Try to update the DEPART table but receive an error because child records must be deleted fi

Author

Abdullah

Language

EN