Figure 1

TCl-Db Database Tables. TCl-Db tables represent the database implementation. PK means primary key, FK means foreign key, U stands for a uniqueness constraint, and I indicates an integrity constraint (in the table ASSERTION there is a check constraint on the column dbsource_id). In database terminology tables are called relations and columns are called attributes, while the other concepts express integrity constraints which guarantee data quality. Here, we use the terms tables and columns when we refer to the physical model which additionally includes a number of materialised views and database functions and procedures. Those are used during database updates, to keep track of unique identifiers and to maintain referential integrity.