Tables Without FKs
|
√
|
√
|
√
|
√
|
Tables With one FK
|
√
|
√
|
√
|
√
|
Tables with more than 2 FKs
|
√
|
√
|
√
|
√
|
Tables that contain exactly 2 FKs with presence of independent attribute
|
√
|
√
|
√
|
√
|
Many-to-many relationship: a table that contains exactly two FKs
|
√
|
√
|
√
|
√
|
FK + NULL + Not UNIQUE
|
√
|
√
|
√
|
√
|
FK + NOT NULL + NOT UNIQUE
|
√
|
√
|
√
|
√
|
FK + NOT NULL + UNIQUE
| | |
√
|
√
|
FK + NOT NULL + UNIQUE + NOT PK
| | |
√
|
√
|
Attribute ( neither PK nor FK
|
√
|
√
|
√
|
√
|
Attribute + NOT NULL
|
√
|
√
|
√
|
√
|
NOT FK + UNIQUE
|
√
|
√
|
√
|
√
|
PK
|
√
|
√
|
√
|
√
|
Attribute with constraint with an integer greater than 0
| | |
√
|
√
|
CHECK with enumeration
| | |
√
|
√
|
CHECK constraint as DataTypeRestriction
| | |
√
| |
The range of the foreign Key
|
√
|
√
|
√
|
√
|
Default Value
| | |
√
|
√
|
Two tables share the same primary key
| | |
√
| |
FK is a reference to the same table
| | |
√
| |
FK is a reference to the same table, but now it is accompanied by a trigger ON DELETE CASCADE
| | |
√
| |