Skip to main content

Table 6 The set of patterns

From: A novel approach for learning ontology from relational database: from the construction to the evaluation

Rules North Ecommerce Sakila Northwind
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    
\