Question: what are the advantages and disadvantages of using generated (surrogate) keys?
Answer: Surrogate keys are unique. Because surrogate keys are system-generated, it is impossible for the system to create and store a duplicate value. Surrogate keys apply uniform rules to all records. ...  Surrogate keys stand the test of time. ...  Surrogate keys allow for unlimited values.