Question

PART I: E-R Diagram Using MS Visio, you have previously practiced creating E-R diagrams. In this exercise, you will read and understand a scenario, identify relevant entities, then create proper ER diagrams You are tasked with drawing an ER diagram for a database that contains companies, departments, employees, employees' dependents (children), and employees' history. Answer each of the following questions (a)-(e) by providing an ER diagranm (a) [10 points] Each company operates four departments, and each department belongs to one company (b) [10 points] Each department in part (a) employs one or more employees, and each employee works for one department. (c) [10 points] Each of the employees in part (b) may or may not have one or more dependents, and each dependent belongs to one employee (d) [10 points] Each employee in part (c) may or may not have an employment history (e) [10 points] Represent all the ER models described in (a), (b), (c), and (d) as a single ER model Your E-R diagram must be as follows An identified entity is to be represented by a rectangle. No need to list attributes within the rectangle An identified relationship between two entities is to be represented by a line. Moreover, the name and the direction (arrow) of the relationship must be shown above (or under) the You must identify the type of each relationship: 1-to-1 or 1-to-M. If there is a limit on the "M", You have the option to draw the diagrams using MS Visio or by hand. If your hand-drawn The following is an example of an ER diagram showing a relationship between teachers and relationship line then you must clearly specify the limit. An example is provided below diagrams are not clear, marks will be deducted subjects, where a teacher can teach a maximum of 5 subjects, but a subject can only be taught by 1 teacher: Teaches Teacher Subject

Answer 1

E- Dapartment Cb) 1. employ Employee c el) EmplouMant may not hau His tory Dependunts

opesates Dapat tenant emplous Em playmant History not have Emplouee ray ar May hot have pendant.s