subject

Draw an ER diagram using the provided information below. Represent the situation as accurately as possible, including all the attributes; 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.

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 21.06.2019 21:30
What is linux? an open source operating system a version of ms dos the first version of unix the newest technology available
Answers: 1
question
Computers and Technology, 22.06.2019 17:00
Your company has 1,500 desktop computers running windows 7. you want to upgrade them to windows 10. which type of microsoft license would be best suited in this situation?
Answers: 3
question
Computers and Technology, 22.06.2019 22:30
Alex’s family members live in different parts of the world. they would like to discuss the wedding plans of one of their distant relatives. however, alex wants all the family members to talk to each other simultaneously so that they can make decisions quickly. which mode of internet communication should they use? a. blog b. email c. wiki d. message board e. instant messaging
Answers: 2
question
Computers and Technology, 23.06.2019 06:00
When is a chart legend used a. all the time b. whenever you are comparing data that is the same c. whenever you are comparing multiple sets of data d. only for hand-drawn charts
Answers: 2
You know the right answer?
Draw an ER diagram using the provided information below. Represent the situation as accurately as po...
Questions
Questions on the website: 13722359