Opening book details…
Can I read Employee and Department Table Creation on EtoBox?
Employee and Department Table Creation by Akash Akm is a document available to read on EtoBox.
What is Employee and Department Table Creation about?
The document contains SQL commands to create two database tables - EMPLOYEE and DEPARTMENT. The EMPLOYEE table has fields for employee number, name, job type, manager, hire date, department number, commission, and salary. The DEPARTMENT table has fields for department number, name, and location. An ALTER TABLE command is then used to add a foreign key that references the department number field between the two tables, linking employee records to department records.
- Author
- Akash Akm
- Language
- EN