I’m having issue’s referencing my pilot(employee_no) to employee(employee_no) if you look in my python code, you can see the error when inserting data into the pilot table. How do I fix this reference issue?
[ER Diagram](https://i.sstatic.net/9XOVw7KN.png)
[Data](https://i.sstatic.net/4acc86EL.png)
[Python Code](https://i.sstatic.net/l0mkog9F.png)
[DDL Part 1](https://i.sstatic.net/1KVU7rO3.png)
[DDL Part 2](https://i.sstatic.net/AObHgm8J.png)
I tried removing the reference employee_no to employee(employee_no), and the data was inserted successfully, but that just removed my problem and isn’t a fix. I also checked and ensured that employee data was inserted before pilot data and that the attribute names are consistent.
New contributor
Max Miller is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.