Hello Firends
I have tables employees and job_history. Employee_id is the primary key in the employee table. In the job_history table, I have employee_id and start_date both as primary key.
How can refer this employee_if (from job_history table) with employee table?
This is query I wrote.
create table job_history (
employee_id number(5) constraint emp_pk primary key
constraint emp\_fk references scott.employee(employee\_id),
start_date date default sysdate constraint sd_pk primary key ,
end_date date default sysdate,
job_id number (5) constraint jobs_fk references scott.jobs(job_id),
department_id number(5) constraint dep_fk references scott.department(department_id)
);
Your help is highly appreciated.