Question 1 [14 marks] An Entity Relationship diagram for an electronics store is given in Figure 1. a Write the set of b

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
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

Post by answerhappygod »

Question 1 14 Marks An Entity Relationship Diagram For An Electronics Store Is Given In Figure 1 A Write The Set Of B 1
Question 1 14 Marks An Entity Relationship Diagram For An Electronics Store Is Given In Figure 1 A Write The Set Of B 1 (86.6 KiB) Viewed 62 times
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!
Post Reply