If a $1$:M relationship is optional on both sides, which of the following is true? The resulting foreign key cannot have null values Two foreign keys are created as a result of the relationship. One can have null values, one cannot. The resulting foreign key must have null values The resulting foreign key can have null values