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