Use these business rules to draw a nice neat ERD.
Following on your job to build an efficient data model for a company that provides conference management services to various organizations; you’ve now obtained business rules, some of which are listed below.
- One Organization has Many Conferences, and possibly none.
- One Conference belongs to One Organization, and not none.
- One Conference has Many Delegates, and possibly none, and a maximum of 400.
- One Delegate attends Many Conferences, and not none.
You have also been given a small sample of their records, in case this may prove useful. It is below.
|
ORG_NUM |
ORG_NAME |
ORG_TEL |
CONF_NUM |
CONF_DATE |
CONF_NAME |
DELG_ID |
DELG_NAME |
ATT_PACKAGE |
|
152 |
Johns Inc. |
021598715 |
101 |
12-03-17 |
PRASA17 |
12 |
F. Freds |
2 |
|
15 |
J. Jacks |
5 |
||||||
|
19 |
P. Petes |
5 |
||||||
|
152 |
Johns Inc. |
021598715 |
102 |
14-04-19 |
PRASA19 |
|
|
|
|
178 |
Petes Inc. |
031568798 |
109 |
16-06-18 |
COPA18 |
11 |
T. Tims |
5 |
|
15 |
J. Jacks |
7 |
||||||
|
22 |
K. Korths |
2 |
Use these business rules to draw a nice neat ERD. Remember that if you encounter any Many-to-Many relationships in the business rules, you will need to first break down and resolve these relationships into a set of business rules in which a bridge entity is created as discussed in class. Clearly show your new business rules if this should be the case.
Step by step
Solved in 2 steps with 1 images
