Is this primary key unique for each record?

Yes, a primary key in a database guarantees the uniqueness of each record in a table. This means that no two rows can have the same value in the column or set of columns defined as the primary key. It ensures data integrity and allows for the unambiguous identification of each record.