I'm trying to create the database for my application, but I cannot manage to normalize my data on a MySQL database.
I have a
Typesof map entity
Typesmust have one or more Models associated to it, in a particular
is_predictionflag and an
Originassociated to it
There can be more than one
Modelusing the same
is_predictioncondition, differing only on the
nameof the model
Originsprovide all the
Typescan only have
Modelsassociated to it that have the same condition of
[Grid, Origin, is_prediction]
I tried to create a table
grid_id, origin_id and is_prediction as foreign key, but it seems wrong, according to the answer on my other question here.
How can I create a normalized database for my needs?
This is what I tried to do: