What happens when a table is activated in DD?
-A table definition is generated
- Map to the database system
-For each table, a table of the same name with the same fields and
corresponding data type is created in database. – Primary index is generated automatically
What is a check table and what is a value table?
· When we define a foreign key in a table (A). If this key refers to primary key of another table (B). Table B is check table
Fields referring to a domain may assume values contained in the
corresponding fields of the value table. Field referring to the domain
should have a foreign key
