Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Arab World (AW) is an intergovernmental organization in the field of the teaching. The main objective of the organization with their professors is to support

image text in transcribed

Arab World (AW) is an intergovernmental organization in the field of the teaching. The main objective of the organization with their professors is to support training plans in Arab countries. AW needs to build a database to record information taking into account the following specifications. 1. Professor is identified by its id. We need also to record his name, birthday, sex and country of citizenship. 2. A Professor has at least one teaching skill. A teaching skill is identified by a skill Id and a name. The professors are ranked in each of his skills according to their years of experience in that skill. 3. To execute and distribute training plans in some countries, the organization cooperate with agencies. Each agency is identified by an id and a name. 4. Countries are identified by their names. For each country, its population and its education index must be also stored. 5. Each training plan is executed in a given country, and the name of the training plan is uniquely associated among the training plans of that country. Each training plan has a budget and is carried out during a period of time. A training plan is always sponsored by one or more agencies. Each agency provides part of the budget of the training plan. The total budget provided by the agencies is never less than the training plan budget. 6. A country accepted by the organization needs some training skills. A training plan designed for a given country covers some of its needs for training skills. 7. A professor may participate in several training plans. The period of time that a professor participates in a training plan must be recorded. A professor cannot participate in two training plans simultaneously. A professor never participates in a training plan more than once. The participation of a professor in a training plan never exceeds the duration of the plan. 8. Each training plan includes at least 10 professors; one of who is the supervisor of the training plan. The supervisor of the plan always works for during the duration of the plan. A professor involved in a training plan must have one of the skills required by the training plan. Draw an E-R diagram for the Arab World database. Arab World (AW) is an intergovernmental organization in the field of the teaching. The main objective of the organization with their professors is to support training plans in Arab countries. AW needs to build a database to record information taking into account the following specifications. 1. Professor is identified by its id. We need also to record his name, birthday, sex and country of citizenship. 2. A Professor has at least one teaching skill. A teaching skill is identified by a skill Id and a name. The professors are ranked in each of his skills according to their years of experience in that skill. 3. To execute and distribute training plans in some countries, the organization cooperate with agencies. Each agency is identified by an id and a name. 4. Countries are identified by their names. For each country, its population and its education index must be also stored. 5. Each training plan is executed in a given country, and the name of the training plan is uniquely associated among the training plans of that country. Each training plan has a budget and is carried out during a period of time. A training plan is always sponsored by one or more agencies. Each agency provides part of the budget of the training plan. The total budget provided by the agencies is never less than the training plan budget. 6. A country accepted by the organization needs some training skills. A training plan designed for a given country covers some of its needs for training skills. 7. A professor may participate in several training plans. The period of time that a professor participates in a training plan must be recorded. A professor cannot participate in two training plans simultaneously. A professor never participates in a training plan more than once. The participation of a professor in a training plan never exceeds the duration of the plan. 8. Each training plan includes at least 10 professors; one of who is the supervisor of the training plan. The supervisor of the plan always works for during the duration of the plan. A professor involved in a training plan must have one of the skills required by the training plan. Draw an E-R diagram for the Arab World database

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Excel Para Auditores Aplicando Excel A La Auditoria

Authors: Antonio P. Peralta C.

1st Edition

9945803697, 978-9945803693

More Books

Students also viewed these Accounting questions

Question

Using Language That Works

Answered: 1 week ago

Question

4. Are my sources relevant?

Answered: 1 week ago