Question 23 its points Create an En Diner for the following the same how how to the many www co write down the following information entity names, entity types strong week or sotiative b. attributes of the entities specity special types of attributes composite multe der e relationship between entities, and attributes of relationships if any. d. Don't forget to show identifiers Example: entity STUDENT strong entity attributes sin identifier name first name.last name date of birth entity CLUB (strong entity, attributes name identifier location date established There is a many-to-many relationship, member of relationship between STUDENT and CLUB. Student side is required. Cu sidit is on There is one attribute of this relationship, date joined There is also a one-to-one relationship. president of relationship between STUDENT and CLUB, Student side is required. CLUB side is optionat, The organization is made up of various departments, each having a name and an identifying number. A department has a stone.nay marryExch employee in the organization is assigned to one department Information about employees includes name, identification number, birth deformation abour employees dependents for instance, children of the employees. If they have any is kept. These include aree sex and birth date. Eclayers may be there Supervised by another employee. A department has an employee who is the manager Each project within the organizadon is controlled by a department. Employees are also assigned to projects. Information about projects includes project rame, round location. A project may be in multiple locations. Hours spent by employees on each project are also kept 3 % A B / Question 23 Fensten 115 points Create an ER Diagram for the following organisation. See the example below shout how to specify the element of your diagram verby Yound to write down the following information a entity names, entity types strong weak or anotiative b. attributes of the entities specify special types of attributes composite, multivalud, derivedi and relationship between entities, and attributes of relationships if any. d. Don't forget to show identifiers Example: entity STUDENT (strong entity, attributes: an identifier name first name, last name date of birth entity CLUB (strong entity attributes name identifier location date established There is a many-to-many relationship, member of relationship between STUDENT and CLUB. Student side is required. CLUB side is options There is one attribute of this relationship. date joined. There is also a one-to-one relationship, president of relationship between STUDENT and CLUB. Student side is required. CLUB side is optional the organisation is made up of various departments, each having a name and an identifying number. A department has at least one many errotestach engloyee in the organization is assigned to the department Information about employees includes name identition number, birth address sex, information about employees dependents for instance, children of the employeesi. It they have any is kept. These include name ser, and the Employees may be direct Supervised by another employee. A department has an employee who is the manager Each project within the organization is controlled by a department. Emplayees are also assigned to projects, Information about projects includes project maneno na location. A project may be in multiple locations. Hours spent by employees on each project are also kg 23 A BEEN
