Draw an ER diagram for the following: A retail company wishes to establish a database system to
Question:
Draw an ER diagram for the following:
A retail company wishes to establish a database system to record information about employees. The employee data to be recorded in the database consist of employee SINs (which are unique), DOB, age, first names, last names and mobile number. The company has two types of special employees as well as many regular employees who do not fit into one of these categories. First, the company has insured employees. For insured employees, the insurance policy number, the insured amount, and the annual premium are to be recorded. The company also has a second type of employees who are the managers. For the managers, the branch number they work at and the number of profit shares are to be recorded. In addition, they need to record data about branches; (unique) branchnumber, budget, and address should be recorded. Employees must work for one, and only one branch. Branches must have at least one employee, and may (of course) have more than one. Each manager normally manages one branch, but on occasion a manager may beresponsible for more than one branch, but never less than one. A branch can have only one manager, but occasionally will not have a manager. It is necessary to record the dependents of insured employees; the first name, age and relationship (e.g. child, spouse, etc.) of each dependent must be recorded. It is assumed that no two dependents of the same employee will have the same name. An insured employee must have at least one dependent; the dependents must have one and only one insured employee.
Database management systems
ISBN: 978-0072465631
3rd edition
Authors: Raghu Ramakrishan, Johannes Gehrke, Scott Selikoff