produced if we followed the relation$-$for$-$relationship translation described in the module?

Question $7$Select one:

A$.$

Relation Container$($RefCode:ContainerReferences, Weight: Weights$)$

primary key$($RefCode$)$

Relation Ship$($RegistrationNum: RegDomain, SailingDate: Dates, Origin: PortNames, Destination:PortNames$)$

primary key $($RegistrationNum$,$ SailingDate$)$

constraint LoadedOn relationship mandatory: each value of $($RegistrationNum$,$ SailingDate$)$ must appear in the LoadedOn relation foreign key attributes RegistrationNum, SailingDate$).$

Relation LoadedOn$($RegistrationNum: RegDomain, SailingDate: Dates, RefCode: ContainerReferences$)$

primary key $($RefCode$)$

foreign key $($RegistrationNum$,$ Sailing Date$)$ references Ship

foreign key RefCode references Container

B$.$

Relation Container$($RefCode:ContainerReferences, Weight: Weights, RegistrationNumber: RegDomain, SailingDate: Dates$)$

primary key$($RefCode$)$

foreign key $($RegistrationNum$,$ Sailing Date$)$ references Ship

Relation Ship$($RegistrationNum: RegDomain, SailingDate: Dates, Origin: PortNames, Destination:PortNames$)$

primary key $($RegistrationNum$,$ SailingDate$)$

constraint LoadedOn relationship mandatory: each value of $($RegistrationNum$,$ SailingDate$)$ must appear in the Container relation foreign key attributes $($RegistrationNum$,$ SailingDate$).$

C$.$

Relation Container$($RefCode:ContainerReferences, Weight: Weights$)$

primary key$($RefCode$)$

Relation Ship$($RegistrationNum: RegDomain, SailingDate: Dates, Origin: PortNames, Destination:PortNames$)$

primary key $($RegistrationNum$,$ SailingDate$)$

constraint LoadedOn relationship mandatory: each value of $($RegistrationNum$,$ SailingDate$)$ must appear in the LoadedOn relation foreign key attributes RegistrationNum, SailingDate$).$

Relation LoadedOn$($RegistrationNum: RegDomain, SailingDate: Dates, RefCode: ContainerReferences$)$

primary key $($RegistrationNum$,$ SailingDate$)$

foreign key $($RegistrationNum$,$ SailingDate$)$ references Ship

foreign key RefCode references Container