Question: i keep getting this error. #1452 - Cannot add or update a child row: a foreign key constraint fails (`cis202920_13`.`titles`, CONSTRAINT `FK_titles` FOREIGN KEY (`emp_no`)

i keep getting this error. #1452 - Cannot add or update a child row: a foreign key constraint fails (`cis202920_13`.`titles`, CONSTRAINT `FK_titles` FOREIGN KEY (`emp_no`) REFERENCES `employees` (`emp_no`))

What am i doing wrong? Here is my coding for creating tables and inserting data into it.This for MySQL for phpMyadmin

create table employees

( emp_no int(11) not null primary key,

birth_date date,

first_name varchar(14),

last_name varchar(16),

hire_date date

)ENGINE=InnoDB;

create table titles

( emp_no int(11),

title varchar(50),

from_date date,

to_date date

)ENGINE=InnoDB;

ALTER TABLE titles ADD PRIMARY KEY (emp_no,title,from_date);

ALTER TABLE titles ADD CONSTRAINT FK_titles

FOREIGN KEY(emp_no) REFERENCES employees (emp_no);

insert into employees

values

(10001,'1953-09-02', 'Georgi','Georgi','1986-06-26'),

(10002,'1964-06-02', 'Bezalel','Simmel','1985-11-21'),

(10003,'1959-12-03', 'Parto', 'Bamford', '1986-08-28');

insert into titles

values

( 1001, 'Engineer','1986-06-26','9999-01-01'),

( 1001, 'Senior Engineer','1995-11-28','9999-01-01'),

( 1002, 'Staff', '1996-08-03','9999-01-01'),

( 1003, 'Senior Enginner', '1995-12-03', '9999-01-01');

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!