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
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.
Step by Step Solution
3.44 Rating (144 Votes )
There are 3 Steps involved in it
ER Diagram is known as EntityRelationship Diagram it is utilized to break down to design of the Database It shows relationships among elements and the... View full answer
Get step-by-step solutions from verified subject matter experts
