Question 1 [14 marks] An Entity Relationship diagram for an electronics store is given in Figure 1. a Write the set of b
-
answerhappygod
- Site Admin
- Posts: 899604
- Joined: Mon Aug 02, 2021 8:13 am
Question 1 [14 marks] An Entity Relationship diagram for an electronics store is given in Figure 1. a Write the set of b
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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!