BC030_App. 5.1
Cardinality
n
n
:
:
m
m
n
n
:
:
m
m
1
C
1
C
N
CN
BC030_App. 5.1
Cardinality
n
n
:
:
m
m
n
n
:
:
m
m
1
C
1
C
N
CN
BC030_App. 5.2
Course Enrolment
STUDENT_ID
?
Foreign Key Field Type
•
Check Table:
Students
•
Foreign Key Table: Course Enrolment
BC030_App. 5.3
Foreign Key Type:
Key Fields or Key Field Candidates
Faculty
Course
BC030_App. 5.4
Foreign Key Type:
Key Fields of a Text Table
T005
(Country Codes)
(T002)
(Language Codes)
T005T
(Country descriptions)
BC030_App. 5.5
Foreign Key Type:
Non-Key Field Candidates
Course
Professor
BC030_App. 5.6
Foreign Keys with Multiple Fields
BC030_App. 5.7
Check Table
Check Table
Field-By-Field Assignment
Foreign Key Table
Foreign Key Table
BC030_App. 5.8
Partial Foreign Keys
BC030_App. 5.9
Constant Foreign Keys
BI
O
BC030_App. 5.10
Changing the Field Assignment
Generic
Checkbox
Constant Foreign
Key
BC030_App. 5.11
Performance of Search Helps
MCS
Employee #
Last Name
Department
MANDT EMPN
DEPT
LNAME
MANDT EMPN DEPT
INDEX
Search Help
Database Table