I have a question on the design of the scheme. I am engaged in the task "airport". There is an essence “flight” and it is necessary to enter there the “place of departure” and “place of arrival” there from the table “airports” (country, city of the airport). How to correctly map this? I after all operate with one table for filling of these fields.

Thank!

  • I after all operate with one table for filling of these fields. Not. You operate with two independent copies of this table. Here on the diagram, these two copies and draw. - Akina
  • Could you throw an example implementation, please? For the first time I come across such a question. - Julia Nechiporuk
  • You could throw an example implementation On SO.ru there is no possibility to attach files. - Akina
  • However, do it yourself. On the new chart, place 2 tables "airports" and one table "flights". In the properties, specify the tables "airports" names / aliases / aliases (depending on which tool you are using) "airports_1" and "airports_2". Associate the field "place of departure" table "flights" with the ID table "airports_1". Connect the field "place of arrival" table "flights" with the ID table "airports_2". Everything, sobsno ... - Akina

0