This question has been answered
Question

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.

Answered by Expert Tutors
Step-by-step explanation
5 Attachments
employee.PNG
PNG
ERd.JPG
JPG
funding.PNG
PNG
manager.PNG
PNG
projects.PNG
PNG
The student who asked this found it Helpful
Overall rating 100%

"Thank you so much"

Design a database of research projects. The database should contain the information about ( but not limit to): - projects: name, manager, budget,...
Get unstuck

252,291 students got unstuck by Course
Hero in the last week

step by step solutions

Our Expert Tutors provide step by step solutions to help you excel in your courses