This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Distinguish between entity identifiers and keys. What will be an ideal ... (Read 43 times)

nummyann

  • Hero Member
  • *****
  • Posts: 576
on: Jul 7, 2018
Distinguish between entity identifiers and keys.
 
  What will be an ideal response?

Question 2

In MySQL, surrogate keys that use a sequence maintained by MySQL should be given a data type of IDENTITY.
 
  Indicate whether the statement is true or false


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

mariahkathleeen

  • Sr. Member
  • ****
  • Posts: 337
Reply #1 on: Jul 7, 2018
Answer to Question 1

An entity identifier is an attribute or group of attributes that is used to name or identify instances of an entity class. Unlike a key in the relational model, an entity identifier is more of a logical concept. It is simply an attribute that the users think of as distinguishing between entity instances in their environment.

Answer to Question 2

FALSE


nummyann

  • Member
  • Posts: 576
Reply 2 on: Jul 7, 2018
YES! Correct, THANKS for helping me on my review

cassie_ragen

  • Member
  • Posts: 347
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

Earwax has antimicrobial properties that reduce the viability of bacteria and fungus in the human ear.

Did you know?

The horizontal fraction bar was introduced by the Arabs.

Did you know?

Cocaine was isolated in 1860 and first used as a local anesthetic in 1884. Its first clinical use was by Sigmund Freud to wean a patient from morphine addiction. The fictional character Sherlock Holmes was supposed to be addicted to cocaine by injection.

Did you know?

Human kidneys will clean about 1 million gallons of blood in an average lifetime.

Did you know?

Hyperthyroidism leads to an increased rate of metabolism and affects about 1% of women but only 0.1% of men. For most people, this increased metabolic rate causes the thyroid gland to become enlarged (known as a goiter).

Some mangrove islands in the Florida Keys, which number in the thousands, are convenient places to t Some mangrove islands in the Florida Keys, which number in the thousands, are convenient places to t
An example of color blindness test. A person with red-green color blindness would not be able to dis An example of color blindness test. A person with red-green color blindness would not be able to dis
Number of lower molar cusps is one of the features used to distinguish sundadonts from sinodonts. Number of lower molar cusps is one of the features used to distinguish sundadonts from sinodonts.
The Number of Children Americans Think Are Ideal The Number of Children Americans Think Are Ideal
Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ... Under ideal conditions, a single cell of the bacterium E. coli would divide every 20 minutes to ...
If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas? If CP for an ideal gas is 35.4 J/molK, which of the following is CV for this gas?
Video: A timeline of the teeth (Explained - No Audio)

For a complete list of videos, visit our video library