What structural role does a primary key perform when enforcing absolute entity uniqueness and indexing records across relational database tables? Furthermore, why is mandating strict non-null and non-duplicate constraints the definitive architectural mechanism to eliminate ambiguous lookups and safeguard relational data integrity?