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