(Solved): Please help | Entity Relationship Diagram, Business Rules. A set of Entity Relationship diagrams a ...

Please help | Entity Relationship Diagram, Business Rules.

A set of Entity Relationship diagrams are given in the following Figures. 1.1. Write the set of business rules reflected in the diagrams. Each relationship must be described by two rules, one in each direction. (10 marks) Figure 1 Each/A/An ENTITY_1 May/Must Relationship_Verb__hrase number ENTITY_2 Figure 2 Each/A/An ENTITY_1 May/Must Relationship_Verb_Phrase number ENTITY_2 Figure 3 Each/A/An ENTITY_1 May/Must Relationshipa_erb_Phrase number ENTITY_2 Each/A/An ENTITY_1 May/Must Belationship_Verb_Phrase number ENTITY_2 1.2. Identify strong and weak entities in Figure 5 below Question \( 1.2 \) Answer: 1.3 Use a weak entity to represent the multi-value attribute skill in the EMPLOYEE entity below. Draw an ER diagram with EMPLOYEE and the weak entity, indicating both the cardinality and optionality on both sides of the relationship. (5 marks) Figure 6