recent changes in privacy laws have disallowed organizations fro

Project Description:

recent changes in privacy laws have disallowed organizations from using social security numbers to identify individuals unless certain restrictions are satisfied. as a result, most u.s. universities cannot use ssns as primary keys (except for financial data). in practice, student_id, a unique identifier assigned to every student, is likely to be used as the primary key rather than ssn since student_id can be used throughout the system.a. some database designers are reluctant to use generated keys (also known as surrogate keys) for primary keys (such as student_id) because they are artificial. can you propose any natural choices of keys that can be used to identify the student record in a university database?b. suppose that you are able to guarantee uniqueness of a natural key that includes last name. are you guaranteed that the last name will not change during the lifetime of the database? if last name can change, what solutions can you propose for creating a primary key that still includes last name but remains unique?c. what are the advantages and disadvantages of using generated (surrogate) keys?
Skills Required:
Project Stats:

Price Type: Negotiable

Expired
Total Proposals: 18
1 Current viewersl
18 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.8
    296 Jobs 214 Reviews
    $0 in 0 Day
  • 4.0
    72 Jobs 31 Reviews
    $0 in 0 Day
  • 4.5
    386 Jobs 254 Reviews
    $55 in 0 Day
  • 4.8
    125 Jobs 89 Reviews
    $0 in 0 Day
  • 3.8
    30 Jobs 19 Reviews
    $0 in 0 Day
  • 4.7
    48 Jobs 26 Reviews
    $10 in 0 Day
  • 4.6
    647 Jobs 468 Reviews
    $0 in 0 Day
  • 0.0
    0 Jobs 0 Reviews
    $0 in 0 Day
  • 4.9
    2109 Jobs 1054 Reviews
    $20 in 0 Day
  • 5.0
    1 Jobs 1 Reviews
    $0 in 0 Day