Due to the modernization of privacy law in America, there are limited cases in which Social Security Number (SocSec#) can be used to identify individuals. As a result, college databases only use SocSec# as a primary key for financial data that may have to be reported to the IRS. This has led to the use of a StudentID (a generated key) field as the unique identifier and therefore primary key rather than SocSec#.

1. Some DB experts do not like to use generated or surrogate keys as the primary key because they are artificial. Suggest a natural key that can be used to identify the student record for DB purposes at Mary Poppins University. Do not include SocSec# anywhere in this natural key. Explain why this works.
2. Suppose you could guarantee uniqueness of a natural key that includes the persons last name. That means that new entries would always have a different last name than the original last name of those in the database.
   1. Could you guarantee that the last name will remain constant during the existence of the DB?
   2. Assuming that the last name could change to an existing last name, provide a solution that will keep the primary key unique but allows the last name to change. Note: The primary key must still include the last name feature. Explain why this works.