Saturday, 22 March 2014
2.Design an ER diagram for the following situation: An organization has two types of employees, salaried and wage earning. Both the types of employees have some common properties, such as employee code, employee name, and employee address. However, the salaried employees have other additional properties: basic, allowance, and House Rent Allowance (HRA). The wage earning employees have distinct properties that are daily wage and overtime.
Subscribe to:
Post Comments (Atom)
: Draw an EERD for the following scenario.
ReplyDeletea) A company has different types of employees. ID and name will be recorded for all employees. A salaried employee will receive basic salary with house rent allowance (HRA). The employees working in hourly basis receive salary on hourly rate. The employees working as consultant will have fixed charges for their salary. An employee cannot belong to two types at a time.
Scenario 1: An Organization depends on a number of different types of persons for its successful operation. The organization is interested in the following attributes for all of these persons: SSN, Name, Address and telephone. A person may have multiple telephone numbers. Three types of persons are of greatest interest: employees, volunteers and donors. Employees only have a date hired attribute, and volunteers only have a skill attribute. Donors only have a relationship (named Donates) with an item that has number(identifier) and name. A donor must have donated one or more items, and an item may have no donors, or one donor. There are persons other than employees, volunteers, and donors who are of interest to the organization, so that a person need not belong to any of these three groups. On the other hand, at a given time a person may belong to two or more of these groups (for Example, employees and donors). Draw an EER diagram based on the requirements above. Write down assumptions (if any) you make in your answer
ReplyDelete