220218
Tables (3)
Department (dept)
- Department Number (deptno) — CHAR(2) — Primary key — NOT NULL
- Department Name (deptname) — VARCHAR(20)
- Department Location (Field2) — VARCHAR(20)
Employees (emp)
- Employee Number (empno) — CHAR(4) — Primary key
- Department Number (deptno2) — CHAR(2) — Foreign key → Department.Department Number — NOT NULL
- Title Number (titleno2) — CHAR(2) — Foreign key → Title.Title Number — NOT NULL
- Employee Name (empname) — VARCHAR(10)
- Manager (manager) — CHAR(4) — Foreign key → Employees.Employee Number
- Salary (salary) — INT(5)
- Hire Date (hdate) — DATE
- Title Number (titleno) — CHAR(2)
- Department Number (deptno) — CHAR(2)
Title (title)
- Title Number (titleno) — CHAR(2) — Primary key — NOT NULL
- Title Name (titlename) — VARCHAR(20)