A software company comprises

a. Human resources including - programmers, managers, maintenance staff,

b. Fixed assets which include - building, computer equipment, software, each identified by a unique id, name / label.

c. Departments for handling different types of projects like internal projects, networking projects, AI projects etc.

Each project has a project lead selected from the group of managers. The team lead selects several programmers and maintenance staff for the project. The projects have a start time, duration and budget amount and are removed from the database of the company once the projects get completed. While a project is live in a department, it is identified by its team lead and its name. Develop the ER model to design the database for the given scenario and derive the relational schema clearly mentioning the different entity sets, relationship sets, constraints.

(You may add suitable constraints and attributes in addition to the given details).

Please send the solution for this fast.