Question: Urgent help required on this question, help needed 14 21 Draw the ER Diagram for the following organization. TUBITAK, Scientific and Technological Research Council of

Urgent help required on this question, help needed 14 21 Draw theUrgent help required on this question, help needed

14 21 Draw the ER Diagram for the following organization. TUBITAK, Scientific and Technological Research Council of Turkey, has many funding programs to support various research projects. TUBITAK would like to keep a research database to track projects and researchers that have received various funds and also their institutions. Various funds are offered by TUBITAK. Funds have a total value. There are also minimum and maximum limits for the amount that can be granted to a research project, the actual amount granted to a project may vary. TUBITAK would like to record the total value and the minimum and maximum limits for funds, as well as their names and descriptions. All funds are of interest, even if the fund may not have been granted to any projects yet. Only projects that have received funds, and only researchers who are working on one or more of these fund receiving projects are of interest to TUBITAK. There may be multiple researchers working on a project, but there must be at least one researcher working on it. Researchers may work on multiple projects and they might have a different role on different projects (e.g., principal investigator, assistant, etc.) A researcher's role on a given project is also recorded. ResearcherID. Name, Date of Birth, Phone Number, Address, and Research Area is of interest about a researcher. A researcher may work in multiple research areas. For a project, its id, title, duration, date fund received and amount of fund received is recorded. TUBITAK would also like to track the institution at which the researcher is working at. A researcher works at one institution, but of course multiple researchers may work at a given institution. Only institutions where a grant receiving researcher works is of interest to TUBITAK. TUBITAK would like to track the institution name, size, type, and address. 1 B 7 TID

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!