Question 1 [14 marks] An Entity Relationship diagram for an electronics store is given in Figure 1. a Write the set of b
Posted: Sun May 15, 2022 1:25 pm
Question 1 [14 marks] An Entity Relationship diagram for an electronics store is given in Figure 1. a Write the set of business rules reflected in the diagram. Each relationship must be described by two rules, one in each direction. (10 marks) Each/A/An ENTITY_1 May Must Relationship. Verb Phrase number ENTITY_2 b. Identify strong and weak entities (4 marks) supervises has assigned to Event Event_ID integer(10) Event_date date N Event_location varchar(15) N Event_time integer(10) N Event Staff EventEvent_ID Integer (10) StaffStaff_ID integer(10) U Staff_position varchar(10) N Event_start Time integer(10) N POD Staff Staff ID integer(10) Staff_name integer10) N Staff_salary integer(10) N Manager_ID integer(10) N Staff Staf ID integer (10) has Skill Skill_ID Integer(10) ☺ Skill_description varchar(20) N belongs to Staff Skill Staff Staff_ID integer(10) SkiSkiN_ID Integer(10) Skill_level integer(10) N Figure 1