8 - Passenger Object Type

Flight alerts have real-world effects on passengers, and you’d like to give your analyst the ability to examine the impact. In this exercise, you’ll create a Passenger object type and establish a link with your Flight Alert object type.

In the previous exercise, you created a one-to-many link type between your Flight Alert object type and the [Example Data] Flight object type.

In this case, because passengers can take multiple flights, and because a flight alert can affect multiple passengers, you will need to create a many-to-many link type instead.

For many-to-many link types, the individual objects can't contain the foreign key of the other object, or there would be duplicate rows in the backing dataset. Instead, we need to work with a join table— a dataset that contains pairs of primary keys that define the links between two object types.

Let's start by generating the backing data needed for your passenger object and link type and then go on to create them in OMA.