(a) Draw the relationship for Q3(a) (i) and Q3(a)(ii). (i) An employee has only one parking space, and special parking s
Posted: Thu Jul 14, 2022 2:28 pm
(a) Draw the relationship for Q3(a) (i) and Q3(a)(ii). (i) An employee has only one parking space, and special parking space is assigned to an employee. (2 marks) (ii) A movie theatre can show many different movies, and one movie can be shown in many movie theatres. (2 marks) (b) (i) What is the purpose of a composite entity? (2 marks) (ii) Explain how do you know whether you need composite entity in Entity Relationship Diagram (ERD) and give ONE (1) example of composite entity. ( 2 marks) (c) Draw a complete Entity Relationship Diagram (ERD) based on Figure Q3(c). FIGURE Q3(c)