- All Info Is Given 1 (96.37 KiB) Viewed 44 times
**all info is given**
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
**all info is given**
**all info is given**
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
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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!