Draw an ER diagram using the provided information below. Represent the situation as accurately as possible, including all the at
tributes; key, composite, derived, multivalued, weak entity, relationships. 1) A Company has many departments; the department includes department_ID, department_name, contact number, company has multiple location of the department. 2) An Employee is assigned to a particular department; one department can have multiple Employees. Employee includes Employee_ID, Employee_name, Employee_address, SSN, contact number, Employee are also divided in permanent, intern, contract. Employee can have Dependent person also; Dependent includes dependent_name, dependent_contact_number, relation with employee, address. 3) Not every Employee is assigned to a Project and each project is managed by only one Department Project includes name of the project, ID of the project, budget of the project. 4) The Company has collaborated with a Bank which provide loan to the company employee at low interest rates. Not every employee has taken loan from the bank, some employees just have their account where their salary gets directly deposited. Read the question properly from start to end before implementing the ER diagram.
1 answer:
You might be interested in