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

Other questions on the subject: Computers and Technology

image
Computers and Technology, 22.06.2019 10:00, IHeartDarkSide03
Which is a false statement considering copyright law? a. when people upload something to the internet they automatically receive a copyright for the work b. the work does not have to contain a copyright notice to be considered having a copyright c. copyright is legal term describing rights given to the creators for literary and artistic works d. personal pictures are always covered by copyrights
Answers: 1
image
Computers and Technology, 22.06.2019 14:20, babyrocks7300
Consider a byte-addressable computer with 16mb of main memory, a cache capable of storing a total of 64kb of data and block size of 32 bytes. (a) how many bits in the memory address? (b) how many blocks are in the cache? (c) specify the format of the memory address, including names and sizes, when the cache is: 1. direct-mapped 2. 4-way set associative 3. fully associative
Answers: 2
image
Computers and Technology, 23.06.2019 03:30, mem81
How can you repin an image on your pinterest pin board a. click on the "repin" button b. click on the "add pin" button c. click on the "upload a pin" button d. click on the "save pin" button.
Answers: 2
image
Computers and Technology, 23.06.2019 12:50, tommy4260
Which syntax error in programming is unlikely to be highlighted by a compiler or an interpreter? a variable name misspelling a missing space a comma in place of a period a missing closing quotation mark
Answers: 1
You know the right answer?
Draw an ER diagram using the provided information below. Represent the situation as accurately as po...

Questions in other subjects: