MAKE ERD A large bank operates several divisions. Information Technology (IT) is operated as one of these divisions. Within the IT division are many departments (have ID, NAME) that are managed by one manager, and all IT employees (HAAVING ID, NAME (composit), SALARY(derived), DESIGNATION, Number, address (composite) age(derived)) belong to one of these departments. The IT division assigns its employees to one or more ongoing projects (HAVE ID, NAME, manager ID, Tasks, completion date etc.) in the bank. A project may be planned, but not have any employees assigned to it for several months. Each project will have a single employee assigned who acts as a project leader. Draw ERD also specify cardinalities between entities.
MAKE ERD
A large bank operates several divisions. Information Technology (IT) is operated as one of these divisions. Within the IT division are many departments (have ID, NAME) that are managed by one manager, and all IT employees (HAAVING ID, NAME (composit), SALARY(derived), DESIGNATION, Number, address (composite) age(derived)) belong to one of these departments.
The IT division assigns its employees to one or more ongoing projects (HAVE ID, NAME, manager ID, Tasks, completion date etc.) in the bank. A project may be planned, but not have any employees assigned to it for several months. Each project will have a single employee assigned who acts as a project leader. Draw ERD also specify cardinalities between entities.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images