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, 23.06.2019 21:50
Description: write function lastfirst() that takes one argument—a list of strings of the format "lastname, firstname" —and returns a list consisting of two lists: (a) a list of all the last names (b) a list of all the first names
Answers: 2
question
Computers and Technology, 23.06.2019 23:00
Lucas put a lot of thought into the design for his company's new white paper. he made sure to include repeating design elements such as color schemes and decorative images. his goal was to a.add symmetry b.create a unified publication c.provide consistency d.save money
Answers: 1
question
Computers and Technology, 24.06.2019 00:20
The guy wire bd exerts on the telephone pole ac a force p directed along bd. knowing the p must have a 720-n component perpendicular to the pole ac, determine the magnitude of force p and its component along line ac.
Answers: 2
question
Computers and Technology, 24.06.2019 10:30
You're programming an infinite loop. what must you include in your code to prevent crashes? in roblox
Answers: 2
You know the right answer?
Draw an ER diagram using the provided information below. Represent the situation as accurately as po...
Questions
question
Mathematics, 09.10.2019 13:30
Questions on the website: 13722363