Question: What is a surrogate key, and when should you use one?

What is a surrogate key, and when should you use one?

Step by Step Solution

★★★★★

3.43 Rating (153 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

A surrogate key is an artificial PK introduced by the designer wit... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

358-CS-DB (635).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

Q:

When should you use a 100% stacked line, column, or area chart? How do the 100% stacked charts differ from stacked charts?

Q:

When should you use a subheading?

Q:

When should you use a TreeSet, and when should you use a HashSet?

Q:

1 a.What is a surrogate key, and when should you use one? 1b. Explain why it might be more appropriate to declare an attribute that contains only digits as a character data type instead of a numeric...

Q:

What is a surrogate key, and when should you use one?

Q:

Database systems chapter 6 review questions. Number 1 2 what is a surrogate key and when should you use one

Q:

When is a table in BCNF? Explain what this means and provide a specific example? What is a surrogate key, and when should you use one? Give specific examples ? What is normalization? Why is it...

Q:

What is an entity supertype, and why is it used? What kinds of data would you store in an entity subtype? What is a specialization hierarchy? What is a subtype discriminator? Given an example of its...

Q:

is it required that every entity instance in the PRODUCT table be associated with an entity instance in the CD table? Why or why not? Is it possible for a book to appear in the BOOK table without...

Q:

List the characteristics that a table must have to be considered a relation. List two synonyms for file, two for record, and two for field. What are the four uses of a primary key? What are the...

Q:

Liquid water flows through a pipe at a mass flow rate of 100 kg/s. If the cross-sectional area of the pipe is 0.01 m2, determine (a) the flow rate of momentum through the pipe.

Q:

Marvin Dinardo manages an auto dealerships service department. Costs and expenses for a recent quarter for his department follows. List the controllable costs that would appear on a responsibility...

Q:

Explain the importance of a code of ethics.

Q:

A farmer has to decide whether or not to plant his crop early. If he plants early and no late frost occurs, he will gain $5000 in extra harvest. If he plants early and a late frost does occur, he...

Q:

Design (through the logical phase) a student advising system that will enable an advisor to bring up the student's complete performance record at the university. A sample output screen should look...

Q:

Explain the significance of the loss of direct, hands-on access to business data that users experienced with the advent of computerized data repositories.

Q:

Looking at the EMP_NAME and EMP_PHONE contents in Figure, what change(s) would yourecommend? PROJ NUM PROJ NAME EMP NUMP NAME JBCODEOB CHO HOUR [PROJ HOURS EMP PHONE 1 Hurricane 1 Hurricane 1...

Q:

QUESTION 2 Project Boyaz is expected to generate $37,000 each year for the next 5 years. It will cost $105,000 to implement the project today. If the project's required rate of return is 13.5%, what...

Q:

Twenty years ago John invested $7,500 in a mutual fund. The value of his investment declined by 19% during the first year and then declined another 30% during the second year. Eighteen more years...

Q:

Your company stock trades for $52.50 per share. It is expected to pay a $2.50 dividend at year end (D1 = $2.50), and the dividend is expected to grow at a constant rate of 5.25% a year. The...