Interface table stores the foreign keys of the table having M:M relationships.
-
True
-
False
Interface tables do not store foreign keys directly for M:M relationships. Instead, they hold data mapped to base tables, while M:M relationships are resolved through intersection tables in the Siebel database schema. The foreign key relationships are established during EIM processing, not stored in interface tables.
To answer this question, you need to understand the concept of M:M (many-to-many) relationships in database design.
In a many-to-many relationship, multiple records from one table can be associated with multiple records from another table. To represent this relationship, an intermediary table, often called an "interface table" or a "join table," is used. This table contains the foreign keys of the tables involved in the relationship.
Therefore, the statement "Interface table stores the foreign keys of the table having M:M relationships" is incorrect.
Option A) True - This option is incorrect because the interface table stores the foreign keys of the tables involved in the M:M relationship, not just one of the tables.
Option B) False - This option is correct because the interface table stores the foreign keys of both tables involved in the M:M relationship, not just one of the tables.
The correct answer is B) False. This option is correct because the interface table stores the foreign keys of both tables involved in the M:M relationship.