Transforming Data Models into Database Designs - Database Processing: Fundamentals, Design, and Implementation - page 251

DRUG Table

DrugNumber Other nonkey data

10
20
30
45
70
90

ALLERGY Table

CustomerNumbe r DrugNumber Other nonkey data

10
20
20
45
30
45
70

1000
1000
2000
2000
3000
3000
3000

Binary MUST NOT Constraint

PRESCRIPTION Table

PrescriptionNumber Other nonkey data DrugNumber CustomerNumber

45
10
70
20

100
200
300
400
500

1000
2000
1000
3000
2000

Figure 6-24
Ternary Relationship with a
MUST NOT Constraint Neither 20 nor 45 can appear here

REPAIR Table

RepairNumber

Other nonkey data

10
20
30
40

TASK Table

TaskNumber Other nonkey data RepairNumber

10
10
10
20
20
30
40

1001
1002
1003
2001
2002
3001
4001

Binary MUST COVER Constraint

AUTO_REPAIR Table

I nvoiceNumber RepairNumber TaskNumber Other nonkey data

100
100
100
200
200

10
10
10
20
20

1001
1002
1003
2001

Figure 6-25
Ternary Relationship with a
MUST COVER Constraint

2002 must appear here