Module –Manipulate aDatabase
TP N°1
Exercise 1:
You are given the MCD representing visits to amedical center:
Figure 1: Conceptual Data Model
Work to do :
Answer the following questions according to the characteristics of this model (indicate if the situation described
is representable with the given diagram).
1. Can a patient make several visits?
2. Can a doctor see several patients in the same consultation?
3. Can several drugs be prescribed in the same consultation?
4. Can two different doctors prescribe the same medicine?
5. Use the Power AMC software to create the MCD of figure N°1
Exercise 2:
In a manufacturing workshop, we are interested in the following information:
1. Team number
2. Name of the employee who is part of ateam 3.
Employee registration number 4.
Qualification of the employee
5. Number of people with qualifications in the company 6Number of
qualified people in ateam
The management rules are as follows:
TP N°1
Exercise 1:
You are given the MCD representing visits to amedical center:
Figure 1: Conceptual Data Model
Work to do :
Answer the following questions according to the characteristics of this model (indicate if the situation described
is representable with the given diagram).
1. Can a patient make several visits?
2. Can a doctor see several patients in the same consultation?
3. Can several drugs be prescribed in the same consultation?
4. Can two different doctors prescribe the same medicine?
5. Use the Power AMC software to create the MCD of figure N°1
Exercise 2:
In a manufacturing workshop, we are interested in the following information:
1. Team number
2. Name of the employee who is part of ateam 3.
Employee registration number 4.
Qualification of the employee
5. Number of people with qualifications in the company 6Number of
qualified people in ateam
The management rules are as follows:
