Page 1 of 1

**all info is given**

Posted: Sun May 15, 2022 1:21 pm
by answerhappygod
**all info is given**
All Info Is Given 1
All Info Is Given 1 (96.37 KiB) Viewed 46 times
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) Staff Staff_ID integer(10) Staff_position varchar(10) N Event_start Time integer(10) N Staff Staff_ID integer(10) Staff_name integer(10) N U Staff_salary integer(10) N Manager_ID integer(10) N Staf/Staff_ID integer(10) has Skill Skill_ID integer(10) Skill_description varchar(20) N belongs to Staff Skill Staff Staff_ID integer(10) SkillskiN_ID integer(10) Skill_level integer(10) N