Design a database of research projects. The database should contain the information about ( but not limit to):
- projects: name, manager, budget, duration ( in years), function agency;
- emplyees: citizen id, name, telephone, email, salary;
- funding agencies: name, address
Each project is funded by a single agency. Project names are unique. An emplyee can be associated with several projects, and a project can be associated with several employees. Managers are employees. You can make any other additional assumotions that make sense in the real world.
Please create ER diagram and data-dictionary for this problem.
252,291 students got unstuck by Course
Hero in the last week
Our Expert Tutors provide step by step solutions to help you excel in your courses