Creation of Tables in Cycles

Creation of tables in cycles involves the following steps:

• First, a table is created with a reference to a table that is not yet created. The table creation is done, but is marked incomplete. No operations (INSERT/UPDATE/SELECT/DELETE) are allowed on an incomplete table.
• Next, when the table with a primary/candidate key is created, the previous table definition becomes complete. If this table also contains the foreign key referencing a table that is not yet created, this table also is marked incomplete. This procedure follows till the last table is created.