A. In the ItemDetail table, making Name plus Site a compound reference to the Item table aligns with relational database principles where a foreign key references a primary key in another table.
C. In the TransactionDetail table, making ID, Owner, and Type a reference to the TransactionHeader table follows the foreign key to primary key relationship as well, where TransactionDetail refers to its header record.
E. In the TransactionDetail table, making ItemName plus ItemSite a reference to the Item table ensures that each transaction detail record is linked to an existing item record, enforcing referential integrity.
B is incorrect because the TransactionHeader table should not reference the TransactionDetail table; it should be the other way around. D is incorrect because the Item table should not reference the ItemDetail table; this too should be the other way around.
References:
Kinaxis RapidResponse documentation on data modeling and relationships between tables.
Standard SQL database design principles as they apply within the RapidResponse environment.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit