original code:
CREATE TABLE `airport` (
  `airport_id` int(11) NOT NULL AUTO_INCREMENT,
  `airport_name` varchar(255) NOT NULL,
  `location_city` varchar(255) NOT NULL,
  `location_country` varchar(255) NOT NULL,
   PRIMARY KEY (airport_id));

CREATE TABLE `airline` (
  `airline_id` int(11) NOT NULL AUTO_INCREMENT,
  `airline_name` varchar(255) NOT NULL,
   PRIMARY KEY (airline_id));

CREATE TABLE `aeroplane` (
  `aeroplane_id` int(11) NOT NULL AUTO_INCREMENT,
  `airline_id` int(11) NOT NULL,
  `flight_name` varchar(255) NOT NULL,
   PRIMARY KEY (aeroplane_id),
   FOREIGN KEY (airline_id) REFERENCES airline(airline_id));

CREATE TABLE `luggage` (
  `luggage_id` int(11) NOT NULL AUTO_INCREMENT,
  `aeroplane_id` int(11) NOT NULL,
  `passenger_id` int(11) NOT NULL,
   PRIMARY KEY(luggage_id),
   FOREIGN KEY (aeroplane_id) REFERENCES aeroplane(aeroplane_id),
   FOREIGN KEY (passenger_id) REFERENCES passenger(passenger_id));


CREATE TABLE `passenger` (
  `passenger_id` int(11) NOT NULL AUTO_INCREMENT,
  `luggage_id` int(11) DEFAULT NULL,
  `flight_name` varchar(255) NOT NULL,
  `name_title` varchar(255) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `dob` date NOT NULL,
  `job_title` varchar(255) NOT NULL,
  `telephone_no` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
   PRIMARY KEY(passenger_id),
   UNIQUE(luggage_id),
   FOREIGN KEY (flight_name) REFERENCES aeroplane(flight_name),
   FOREIGN KEY (luggage_id) REFERENCES luggage(luggage_id));




CREATE TABLE `emergency_services` (
  `service_id` int(11) NOT NULL AUTO_INCREMENT,
  `flight_name` varchar(255) NOT NULL,
  `passenger_id` int(11) NOT NULL,
  `total_passengers` int(11) NOT NULL,
  `weather_condition` varchar(255) NOT NULL,
   PRIMARY KEY(service_id),
   FOREIGN KEY (passenger_id) REFERENCES passenger(passenger_id),
   FOREIGN KEY (flight_name) REFERENCES aeroplane(flight_name));

CREATE TABLE `flights` (
  `flight_id` int(11) NOT NULL AUTO_INCREMENT,
  `flight_name` varchar(255) NOT NULL,
  `going_to` varchar(255) NOT NULL,
  `coming_from` varchar(255) NOT NULL,
  `departure_date` date NOT NULL,
  `arrival_date` date NOT NULL,
  `delays` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
   PRIMARY KEY (flight_id),
   FOREIGN KEY (service_id) REFERENCES emergency_services(service_id));



CREATE TABLE `worker` (
  `worker_id` int(11) NOT NULL AUTO_INCREMENT,
  `job_name` varchar(255) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `dob` date NOT NULL,
  `telephone_no` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `Salary` int(11) NOT NULL,
   PRIMARY KEY(worker_id));


working code:
CREATE TABLE `airport` (
  `airport_id` int(11) NOT NULL AUTO_INCREMENT,
  `airport_name` varchar(255) NOT NULL,
  `location_city` varchar(255) NOT NULL,
  `location_country` varchar(255) NOT NULL,
   PRIMARY KEY (airport_id));

CREATE TABLE `airline` (
  `airline_id` int(11) NOT NULL AUTO_INCREMENT,
  `airline_name` varchar(255) NOT NULL,
   PRIMARY KEY (airline_id));

CREATE TABLE `aeroplane` (
  `aeroplane_id` int(11) NOT NULL AUTO_INCREMENT,
  `airline_id` int(11) NOT NULL,
  `flight_name` varchar(255) NOT NULL,
   PRIMARY KEY (aeroplane_id));


CREATE TABLE `luggage` (
  `luggage_id` int(11) NOT NULL AUTO_INCREMENT,
  `aeroplane_id` int(11) NOT NULL,
  `passenger_id` int(11) NOT NULL,
   PRIMARY KEY(luggage_id));



CREATE TABLE `passenger` (
  `passenger_id` int(11) NOT NULL AUTO_INCREMENT,
  `luggage_id` int(11) DEFAULT NULL,
  `flight_name` varchar(255) NOT NULL,
  `name_title` varchar(255) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `dob` date NOT NULL,
  `job_title` varchar(255) NOT NULL,
  `telephone_no` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
   PRIMARY KEY(passenger_id),
   UNIQUE(luggage_id));





CREATE TABLE `emergency_services` (
  `service_id` int(11) NOT NULL AUTO_INCREMENT,
  `flight_name` varchar(255) NOT NULL,
  `passenger_id` int(11) NOT NULL,
  `total_passengers` int(11) NOT NULL,
  `weather_condition` varchar(255) NOT NULL,
   PRIMARY KEY(service_id));


CREATE TABLE `flights` (
  `flight_id` int(11) NOT NULL AUTO_INCREMENT,
  `flight_name` varchar(255) NOT NULL,
  `going_to` varchar(255) NOT NULL,
  `coming_from` varchar(255) NOT NULL,
  `departure_date` date NOT NULL,
  `arrival_date` date NOT NULL,
  `delays` int(11) NOT NULL,
  `service_id` int(11) NOT NULL,
   PRIMARY KEY (flight_id));




CREATE TABLE `worker` (
  `worker_id` int(11) NOT NULL AUTO_INCREMENT,
  `job_name` varchar(255) NOT NULL,
  `first_name` varchar(255) NOT NULL,
  `last_name` varchar(255) NOT NULL,
  `dob` date NOT NULL,
  `telephone_no` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `Salary` int(11) NOT NULL,
   PRIMARY KEY(worker_id));


ALTER TABLE aeroplane
ADD FOREIGN KEY (airline_id) REFERENCES airline(airline_id);

ALTER TABLE luggage
ADD FOREIGN KEY (aeroplane_id) REFERENCES aeroplane(aeroplane_id),
ADD FOREIGN KEY (passenger_id) REFERENCES passenger(passenger_id);

ALTER TABLE flights
ADD FOREIGN KEY (service_id) REFERENCES emergency_services(service_id);

ALTER TABLE passenger
ADD FOREIGN KEY (luggage_id) REFERENCES luggage(luggage_id);

ALTER TABLE emergency_services
ADD FOREIGN KEY (passenger_id) REFERENCES passenger(passenger_id);


lines not working:

ALTER TABLE passenger
ADD FOREIGN KEY (flight_name) REFERENCES aeroplane(flight_name);

ALTER TABLE emergency_services
ADD FOREIGN KEY (flight_name) REFERENCES aeroplane(flight_name);