Advantages and disadvantages of using generated keys

Assignment Help Basic Computer Science

Reference no: EM131054246

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?

Reference no: EM131054246

Questions Cloud

Journal reports the asked price for the bond : A government bond with a coupon rate of 8% makes semiannual coupon payments on January 9 and July 9 of each year. The Wall Street Journal reports the asked price for the bond on January 24 at 100:17. What is the invoice price of the bond? The coup..

Write a python program to demonstrate a theme for your robot : Write a Python program to demonstrate a theme for your robot. Your team must think of something fc your robot to do using the sensors and/or motors.

What is the present value : What is the present value of $13,750 to be received 4 years from today if the discount rate is 4.75 percent?

Differences between it and operational planning : What is Strategic planning it's traits what it involves and the main differences between it and operational planning.

Advantages and disadvantages of using generated keys : What are the advantages and disadvantages of using generated (surrogate) keys?

Cost of healthcare services : How might the ways in which we produce, deliver, and pay for care be changed in order to increase access, improve quality, and the the cost of healthcare services?

Different legal forms for a firm : Question: You want to compare the earnings from two different legal forms for a firm: Corporate and Proprietor. Your pre-tax income is $500,000 in both. However there is a difference in the taxes you pay.

What aspect would you consider most critical or important : What do you find unusual or of interest as a forensic or crime scene investigator working in today's technological environment? What in your opinion was mishandled in this case based upon what you have read regarding the case in your text?

Initial cash flow for new prroject : Samson's now wants to tear down the original structure and build a new strip mall on the site at an estimated cost of $2.3 million. What amount should be used as the initial cash flow for new prroject?

User Account

All Pages