20240319
Tables (5)
Car (car)
- Car Id (car_id) — int — Primary key — NOT NULL
- Car Number (car_number) — varchar(8)
- Image (car_img)
Department (dept)
- Department Id (deptno) — int — Primary key — NOT NULL
- Name (dname) — varchar(20)
- Location (loc) — varchar(20)
Employee (emp)
- Employee Id (empno) — int — Primary key — NOT NULL
- Name (ename) — varchar(10)
- Job (job) — varchar(20)
- Manager (mgr) — int
- Hire date (hiredate) — date
- Salary (sal) — int
- Commission (com) — int
- Department Id (deptno) — int — Foreign key → Department.Department Id — NOT NULL
Employee's Car (emp_car)
- Employee Id (empno) — int — Foreign key → Employee.Employee Id — NOT NULL
- Car Id (car_id) — int — Foreign key → Car.Car Id — NOT NULL
- Mileage (mileage) — int
Salary Table (salgrade)
- Grade (grade) — int — Primary key — NOT NULL
- Low salary (losal) — int
- High salary (hisal) — int