Give a Relational Model that corresponds to the Entity-Relationship Diagram given below: address M M Participates 1 Евployee Project Uses Supplier 1 person married to lti is_Harried to City You can...

Extracted text: Give a Relational Model that corresponds to the Entity-Relationship Diagram given below: address M M Participates 1 Евployee Project Uses Supplier 1 person married to lti is_Harried to City You can present this model as a Relational Database Schema or as a diagram. It must be clearly stated what primary and what foreign keys are and what the foreign keys reference. You may want to use the translation explained in Topic 2.2, but only provide your final result (don't show your working). In your schema you are supposed to use the same names for attributes and relations as given in the diagram.


Extracted text: 3. Give TWO constraints on relationship is Married.To that are not in the Entity-Relationship diagram above, because they cannot be ex- pressed as structural constraints. The constraints should not be do- main constraints but concern how entities can be associated in this relationship. [12 marks]